View Single Post
  #2  
Old November 14th, 2009, 02:01 AM posted to microsoft.public.access.tablesdbdesign
Barry A&P[_2_]
external usenet poster
 
Posts: 119
Default Sum of every page in a report

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

"Reva" wrote:

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?