Does anyon ehave any experience of running totals in an access query.
I'm reporting the data through excel not access reports so need a query not a report solution..

I have a table which looks:

Region Category Type Desc Period_IDPeriod_YTD Period Total
Canada Events WSOP Team 6 7 Budget 15000
Canada Events WSOP Team 7 8 Budget 0
Canada Events WSOP Team 8 9 Budget 0
Canada Events WSOP Team 9 10 Budget 0
Canada Events WSOP Team 10 11 Budget 0
Canada Events WSOP Team 11 12 Budget 0
Canada Events WSOP Team 12 13 Budget 0
Canada Events TOTAL All 1 2 Budget 15000
Canada Events TOTAL All 2 3 Budget 15000
Canada Events TOTAL All 3 4 Budget 15000
Canada Events TOTAL All 4 5 Budget 15000
Canada Events TOTAL All 5 6 Budget 15000

What I would like is to have an additional column which keeps a monthly summary of spend based on running total month 1to 12. All items have months 1 - 12 and are ordered in that fashion.

Any helpo really appreciated.

Simon

Do a search. Been done many times in these forums.