Quote:The relative path needs to be from the CWD of the Sesame Executable so if the CWD of Sesame is C:\Sesame then the relative path would be Miara\MonthTotals.db.
The exe is in C:\Sesame\Program, so I'm not sure how to navigate from there. But it's not important, because eventually the db will be on the server, and I'm sure that will change everything. For now it's no trouble to point straight at it, the lookup is working well, thanks again for your guidance.
Quote: The only change I can recommend to that code is to wrap the @XLookup in an @ToNumber() or @ToMoney() that way Sesame is not guessing on how to do the conversion. I forgot it in my code example, sorry about that, too many things at once.
I have now done that, @ToMoney, and thanks for the suggestion. I'm going to post a note above my monitor to remind me to specify these things in the future so I don't have to make Sesame do more work than is needed. Or you, for that matter. Take a break, you've earned your pay today, the coffee and doughnuts are on me!
Quote:Hmm. How many events do you have the programming in that adds the value of the invoice to the Running_Total? I'm wondering if perhaps on an element in the group or view header as well as in an element in the group body(which is where it should be)
You guessed it! (Or did you peek?) I'm still unfamiliar with programming reports so I wasn't aware of the "doubling" of header names and elements and didn't scroll far enough down when choosing the element to program, so I was fighting with the Q&A programming that was already there. These Q&A reports are a pain in the ass, probably easier to start from scratch than try to redesign them all.
Thanks again, Ray, I can't say thanks enough!