generate cummulative data

[charlesdicken]

Can I set any formula in query to calculate cumulative data at each row?
eg. I have a table that shows cashflow for at each row end and I would like to add a new column that show at each row's end as cumulative cashflow (assume the table already being sorted by date).


Thanks a lot.

[ajetrumpet]

yes you can, and ms was about the first one to explain how, the simplest way: http://support.microsoft.com/kb/290136