Running Total/Balance

[Guest]

Good Day,

I have a query that contains a column CR_DRAmount -- this contains positive
& negative entries from my table.

How do I create a running total/balance for this field/column.

The column uses an expression:

CR_DRAmount: IIf([Wire]=True,[CR_DRAmt]*-1,[CR_DRAmt])


Thanks,

Brook

 

[Jeff Boyce]

Brook

You'd probably need to build that running total/balance into a report. The
query (you posted in a query newsgroup) would return all the rows, and your
report could keep a running total.