(Q) I want to show a total at the bottom of each
page, but I keep seeing #error instead, whats wrong?
(A) Your problem is that access does not allow the Sum() function in
the page footer. So to get around the problem, create a control in another section of your
report that performs the calculation, and set its visible property to false. Then create
another unbound text box in the page footer. Enter the name of the control containing the
calculation as the text boxes controlSource property setting.