How to print page totals in your reports

[CosmoKramer]

This can be done with just a little bit of code........

Add an unbound text box to your detail section (for example, txtSum) and set it to be invisible.

In the On Format event of your page header section, put the following code:

txtSum = 0

This will reset the variable to 0 for each new page.

In the On Format event of your detail section, put the following code, of course changing txtFieldToBeSummed to your field to calculate:

txtSum = txtSum + txtFieldToBeSummed

Add a text box to your page footer to display the page total. Set its control source to =[txtSum] which holds the last running sum amount.