DSUM Error

[wheatlandacctech]

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

[Bob Fitz]

The third argument for DSum() requires a criteria expression. In a query sorted by RegAcctID, try something like:
RunningSum: DSum("GLBalance","tblGeneralLedger","RegAcctID<" & RegAcctID)

That said, I think you'd be better using a report rather than a query to get a running total.

[June7]

Agree, textbox on report has RunningSum property.

Also, domain aggregate functions can cause slow performance in query with large dataset.

Can be done with a correlated subquery but not sure performance would be faster.