Performing calculations in page headers/footers in reports

[horseridingjo]

Hi,
Does anyone have a simple way to sum an amount column in a text box within the report page footer and then in the next page (page2) have a text box in the page header that carries over the previous total (that is in the page footer of page 1)? Then on page 2 of the footer, the text box should total up the carried over amount and the page 2 amount and so on. Therefore, page header of page 3 carries over to total page amounts from pages 1 & 2.
From lots of reading on forums, I understand that this cannot be a simple SUM method as this doesnt work in report page headers and footer.
Does this make things simpler?
Regards,
Jo

 

[Trevor G]

Jo,

Microsoft Provide a sample database for Reports, Queries, Forms and the link below will give you a sample on how to place in page values in a footer.

http://www.microsoft.com/downloads/...A5-C76F-4EDA-BC9A-5FAC336EF7F1&displaylang=en