Reports:Printing Totals on a Page

Thursday, December 19, 2002 21:27:04

To print totals on a page-by-page basis rather than report basis, you would not do the typical =Sum([txtAmountField]) method. Rather you would: (let's say the field being added is called "number_of_operators":

Create a new text box in the detail section, name it RunSum (in this example)

Assign it the following properties:

Name: RunSum
Control Source: number_of_operators
Visible: No
Running Sum: Over All

Create a new text box in the report's page footer section, and assign it the following properties:

Name: txtTotalOperators
Control Source: =[RunSum]

For more information:

For Access 97 see Microsoft Knowledge Base Article 132017.

For Access 2000 see Microsoft Knowledge Base Articles 210261 and 216311. (There is also a Microsoft 2002 version at 296249.)