Hello,
I searched this forum for an answer but didn't seem to find any posts that related to my problem. I've got a table named tblGeneralLedger. In that table, I've got a field that's a calculated field called GLBalance. I want to have a running sum or the GLBalance field. I've got another field in my table that's called RegAcctID which is the foreign key to the table called tblRegisterAccounts. I know I've probably missed something. Here is my DSUM expression that I used. RunningSum: DSum("GLBalance","tblGeneralLedger","RegAcctID") I keep getting an error message that says it can't find the "RegAcctID" field. What am I doing wrong?
I'm sorry if my question isn't clear or if someone has already posted a similar post.
Thanks for you help in advance!
Joel