You need to create in your report a group on the date field. To do this,
click on the Sorting and Grouping icon. For the group properties set Group
On to Month (important). You will also need a group footer. Put a text box
with =Sum([your amount field]) (as the control source) in the footer. Below
this, put a page break. This should give you a total by month and then eject
a page (why would you want the total on the next page?).
You can find out how to make totals in the Help.
You might also want to consider using the Report Wizard.
Robert Crouser
"Andy V" <ra***********@hotmail.com> wrote in message
news:bj**********@ctb-nnrp2.saix.net...
Hi. I've got a multi page report of my monthly purchases. I'd like a
running total (month to date) at the end of each page and to have that total at
the top of the following page. So far all I can figure out is a grand total at
the end of the entire report!
Any suggestions? Thanks.