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.
