Running Total by Item Number

[Dave1225]

I need to create a query that gives me a running total by item number - like in the excel example below. How can I set this up in Access? My table would have Item Number and Order Qty only. Thanks for any info.

Item Number ID	Order Qty	Running Total
261	4	4
261	4	8
261	4	12
261	4	16
5312	6	6
5312	6	12
5312	6	18
5312	6	24
5644	96	96
5644	96	192
5644	96	288
5644	96

[June7]

Easiest way is to build a report. Textbox on report has a RunningSum property.

Otherwise, review http://support.microsoft.com/kb/290136