How to add the current row data (as number) to the aggregated sum?

M

MarcBey

Hi all,

I wonder how the require must look like to add the current row data (as
number) to the aggegated sum which is the sum of all the existing numbers up
to this row?

Hope an example explains it better;)
Number: Current Sum:
Row 1: 10 10
Row 2: 15 25
Row 3: 20 45

Thanks for any help!
Marc
 
J

Jeff Boyce

Marc

One way to do this would be to use the base query to feed a report, and in
the report, use the running total property.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top