By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,542 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

Multi Page Report Subtotals

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.