Is there a way to carry balances forward in access

[57oln]

Hi all,

I again needs some help and am somewhat stuck.

I have a report which is grouped by month and then sorted by year. So we can compare work flow for the same month over years. Each month then has a total of unprocessed information. I have tried to demonstrate it in the table below.

Month	Year	Queue	Job1	Job2	Job 3
1
	2012	Post	904	63	24
		Processed	376	47	0
Unprocessed total			528	16	24
	2013	Post	544	70	26
		Processed	308	24	0
Unprocessed total			236	46	26
2
	2012	Post	760	139	15
		Processed	252	137	0
Unprocessed total			508	2	15

<tbody>
</tbody>

The unprocessed total is a calculated field within the "Year" Footer of the report and the calculation is within the report itself.

I have been asked to have the unprocessed total carry forward. i.e. Job 3 in Month 1 2012 had 24 unprocessed records, so Job 3 in Month 2 2012 should be the 24 from Month 1 plus the 15 in Month 2 giving a total of 39.

This needs to work for Months 1 to 12 and then roll over to Month 1 in the next year.

I have tried to think about it and am leaning towards adding something to something like count the month before to the calculated field, but I have a headache setting in and this is beginning to be over my head......can anyone help??

Thanks in advance

 

[Kreszch68]

What exactly do you mean by the months being grouped together? What you should have, is the months being set as a group, with a group footer for the totals of each month. If you do this, I'm quitte sure you will get the correct running totals as you want them to be. So to make sure we are on the same page, in your report you needs to have year as a group, and within this group you make a grouping for the months. Then in the group footer of the month you place the running total, as total over all.