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

  • Thread starter Thread starter MarcBey
  • Start date Start date
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
 
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
 
Back
Top