Running Totals

[Tom W]

Can I use Macros to calculate running totals?
Example:
Qty Cum Total
2 2
10 12
3 15

 

[Piers 2k]

Tom,
Not sure, but it's easy to do this in a report anyway.

=Sum([field_name]) and set it's Running Sum property to Yes. Put this in the
Group footer and it should work fine.

Piers.


| Can I use Macros to calculate running totals?
| Example:
| Qty Cum Total
| 2 2
| 10 12
| 3 15

 

[Guest]

Thank you. I am hoping that I could update the field
using a query.