Running total

[edwardcga]

I am creating a report that have a main form and subform. I try to cumulate total of cash (in the Header table only) for the transactions selected by date range.


I created a text field with the formulae:
=[CASH_05]*5+[CASH_10]*10+[CASH_20]*20+[CASH_50]*50+[CASH_100]*100+[CASH_COINS]*1. I place this in the page header and also group header (for each offer ID in main table) but it keeps repeating the total of the first ID for all the other IDs.
I would like to know how I can resolve it.

Thanks

EW

[June7]

Multiple similar name fields indicates a non-normalized data structure.

If you want to provide db for analysis, follow instructions at bottom of my post. Identify the report object involved.