Page Summary

[Carl Foster]

Hi

I'm creating a report with a whole list of currency transactions. The report needs to sum up values and display a running total at the bottom of each page and then a "Totals carried forward" at the top of page 2 with a final sum at the end of the report.

I can achieve a final report total but I can't work out how to get a page total and carried forward amount. Any ideas?

 

[Dennisk]

If I remember rightly (Not done this since 1999) use the report detail on print event to perform your totaling.

 

[Carl Foster]

Haven't done this for a while and just resurrecting this thread again.

I am using Access 2007 in which you can easily create summaries for groups and for the entire report using a textbox and this within the control source =Sum([curReceiptsIn]) where curReceiptsIn is a control within the report.

My problem is that if you try putting this in the page footer it comes up with #Error, and no summary. Is there a way I can summarise a pages worth of information and carry it forward to the next page? If I have to use code for this I'm not familiar with reports so much so wouldn't know how to refer to the page.

 

[Carl Foster]

Actually, I've just found something in MSDN that I think will help. If anyone is interested heres the link:

http://support.microsoft.com/kb/296249