Sum of every page in a report

R

Reva

I have a multi page report which includes a field to calculate the
[Qty]*[Rate]. I would like to have a sum shown at the bottom of each page
and a grand total at the end of the report. Can anyone suggest how to sum
the [ExtendedCost] at the end of each page?
 
B

Barry A&P

Reva
depending on grouping and report setup and im sure lots of other stuff Try a
control on your reports page footer for =sum([name of your details control
with qty*Rate]) and same thing in the reports footer. but i am not exactly
sure about your page breaks ext..

or create a new report with the report wizard and check out the "Summary
Options" button when it asks you about sorting and see how the wizard does it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top