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

[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

 

[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