Displaying Accumulative for each record

[Gurmit]

I have a query which selects certain record. I then use a form to display these records in a tabular format. For each record I would like to dispaly a running total (accumulative).
Example

If I have five record with field say Amount and values are 10,20,25,30 and 50

On the first line I would like the TOTAL =10
next line TOTAL=10+20=30
next line TOTAL=30+25=55
and so on.

Can anyone help with this? Your help will be appreciated

 

[neileg]

Very easy to do in a report which has built in support for a running total.

 

[Gurmit]

Thanks Neil

Gurmit

 

[Cosmos75]

This can be done in a query, but a report is better if all you need to do is display the data.

Running Calculations (Total/Sum, Average, Count) in a Query