How can I get Cumulative results down a calculated field “column” in Access?

[David Ball]

Hi Forum,

I have a query with a field for “Item_Number” that has items 1 to 33 running down the page. Beside that is a field of values for “Quantity” and another field for the month and year (eg. Jan 2015, Feb 2015, Mar 2015, etc). I run a report that shows the quantity by date.
I now need to run a query that sums the quantities in a cumulative fashion. So, I would have the quantity for item 1, then the next value down would be the quantities from items 1 and 2 added together, etc, until I have the grand total at the bottom of the page at item 33.
This is so easy in Excel but I can’t think how to do it in Access.
Any ideas, please?

Thanks very much
Dave

 

[spikepl]

A textbox in a report has a property to set it to running sum