Sum of every page in a report

  • Thread starter Thread starter Reva
  • Start date Start date
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?
 
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
 
Back
Top