Totalling Pages in a Report

[bdj]

I have a query that produces about 90 results which I want to list with 10 to a page and a total for that page in the page footer – not a running total for the report and not grouped.

Can anyone advise me of the easiest method.

The report is basis on a payform and will only accept 10 lines of input but each payform needs to stand alone with the necessary signature etc. That is why I need each page to be totalled separately

Any help would be appreciated

 

[Rich]

Article ID: Q132017

 

[bdj]

thanks for the help

BJ

 

[bdj]

HELP _ GREMLINS ABOUT

After having completed the instructions in Q132017 I found that everything worked perfectly - ON THE SCREEN.

Each page was added correctly and seemed to be the perfect solution until I went to print it out and found a grossly distorted negative number as the sum of the first page. It didn't matter what I did it insisted on printing out a rubbish total for the first page but displays the correct answer in print preview.

Any ideas

 

[Rich]

Use the OnPrint event

 

[Lushman]

what is Article Q132017 and and How get to look at it.

 

[bdj]

If you go into www.microsoft.com and then go into the knowledge base and do a search on any problems or use the Q series number then if a problem has been resolved or it is a known problem details will be displayed