Running totals in the page footer

[Kathleen]

I would like to show a total at the bottom of each page of a report but the records cannot be grouped. They print in a format that requires 5 records per page.<br>
<br>
A group footer is not the answer and the report footer does show the grand total fine.<br>
<br>
I believe there is a way to show a running total in the page footer. Maybe by attaching a module to the section? I am not a VB person but can stumble through simple modules here and there.<br>
<br>
Thanks for any help.<br>
<br>
Kathleen

 

[WP]

Put it in the page footer.<br>
<br>
=Sum(yourfieldname)<br>
<br>
WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[Dawnit]

Bill, your solution only showed literally: &quot;=Sum(field name)&quot;

I would also like to do what Kathleen wants, but I suspect that expressions do not work in page and report footers.

Any other suggestions?