subtotal in report

C

corfiotis

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
 
A

Allen Browne

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.)
 
Top