Question Locked

How do I use DSum to keep a running balance by date in Access query?

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The formula I'm trying to use is: Balance: DSum("[SumOfCredit]+[CDebit]+[CFees]","qryCheckDt","[TransDate]<=Now()"), with the Totals field set to "Expression." CDebit is just monetary value of debit multiplied by -1, and likewise for CFees. I'm trying it from a query where I've summed Credit, Debit*-1, and Fees*-1 in order to have only one line per Transaction Date ("TransDate").

I managed to get it to work without an initial error, but it returns the same value on every line, and I can't figure out why.

1 reply

This discussion is closed to new replies.