subtotal in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

please can anyone help me.I want in a report with many pages every page to
have its total and of course in the end of the report the grand total.in case
i can carry the total of each page in the begining of the next one it will be
very good.

Thanks
Achilles
 
Access does not give you totals in the Page Footer.

You can collect them programmatically, as described in this article:
Reports: Page Totals
at:
http://allenbrowne.com/ser-11.html

For the grand total, use:
=Sum([MyField])
as you normally would. Trying to collect a total in the report events over
several pages is not reliable. (The events don't all fire unless you print
all pages of the report.)
 
Back
Top