Running Totals

[Ed]

Hi
I have a table with the following data...

Date Check# Amount
10/1/05 100001 100
10/2/05 100002 200
10/2/05 100003 300
10/3/05 100004 400

How am I able to generate the report like the following, I undstand the it
should be in the detail section but I am not sure how to generate the Totals
column with the add up of the last Total...

Date Check# Amount Totals
10/1/05 100001 100 100
10/2/05 100002 200 300
10/2/05 100003 300 600
10/3/05 100004 400 1000

Thanks

Ed

 

[Duane Hookom]

Check the Running Sum property of a text box.

 

[Ofer]

Add another field next to the Amount field, that is bound to the Amount field
in the table, and set the running sum to yes