Chart report showing a cumulative total

[coastguard]

Hi,

I'm trying to create a report which shows the month by month cumulative totals for 6 outworkers so that I can stay within my overall budget.

For example, in April I know what my budget for the forthcoming year is (actually I get it around June but that's another story).
So each month I run a query which totals up what each worker has cost me that month. Towards the end December I want to be able to run a report which will show me the cumulative totals month on month so that I can see at a glance if I'm, likely to go over budget or not.

I'm really stuck on how to do this so if anyone has any ideas or can point me in the right direction I'd appreciate it.

 

[Rich]

Use a Totals query to start with

 

[coastguard]

Sorry Rich, I'm obviously missing something or I'm not explaining myself too well. I have got a Totals Query to Give me a total for Worker A for each of the months April, May, June etc; Worker B for each of the months April, May, June etc and so on for the six workers.

I now want to be able to some how get this into a chart format that in July will show me each of the workers' cumulative month on month total.
For example; worker A's April total, Worker A's April and May totals added together, Worker A's April, May and June totals added together etc.

 

[coastguard]

OK, now i'm getting somewhere. I'm creating a new calculated field in the query and it seems to be doing what I want.

Thanks for the steer Rich.