Calculating Page Totals

[DavidWill]

Hi,

I'm fairly new at Access and would like to know to how to create page totals. I'm creating a multi-page invoice. The customer has asked that at the end of each page a total be displayed for the invoice items on that page. Also on the last page they asked to display summary lines of each page total followed by a grand total of the invoice. Something like:

Page 1 - Total: ########
Page 2 - Total: ########
Page 3 - Total: ########

Total Invoice Amount: ##########

Any help would be greatly appreciated.
Thanks,
Dave

 

[CosmoKramer]

You should be able to put your calculated field in the page footer to get the value for each page. The only drawback is that on the last page the report footer will probably appear before the page footer.......