Totals in Page Heard instead of Report Footer

[royalrochelle]

I have a report that calculates the totals and displays it in the Report Footer. I want these same totals to display in the Page Header instead. When I put the code in the Page header it will calculate the numbers page by page. Meaning, the 1st page will say the totals for that page, the 2nd page will say the totals for the 1st and 2nd page, etc..until finally the last page will have the complete totals. So I decided to keep the totals in the Report Footer but make it invisible and have the text boxes in the Page Header equal the totals in the Report Footer. It works but only if I make the Report Footer visible and scroll to the last page to view the totals, open the report up in design view, make the Report Footer invisible, and when I open up the report the totals are now in the Page Header.

Does anyone know a way to make the totals appear on every page in the Page Header without all of those steps I go through?

 

[llkhoutx]

That's what your supposed to get in a page header or footer.

If you want the grand total in the page header use a subreport or a DLookUp function for the total. A subreport will execute faster.