cumulative sum how

[arctushar@yahoo.com]

Hellow
I want to make a query where it shows cumulative search. How can I do that. for example
In a stock table there is receive data as below

• 10
• 5
• 16
• 12

Now query will show as below

• 10
• 15
• 31
• 43

How can I do this. can anybody help me?

[pbaldy]

Search on "running sum". It is typically done with either a DSum() or subquery that sum all values equal to or less than the current record (based on a sorting field).

[ajetrumpet]

and to expand on Paul's...http://support.microsoft.com/kb/290136