subtotal in report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

corfiotis - 31 Jul 2005 07:48 GMT

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

Reply to this Message

Allen Browne - 31 Jul 2005 09:10 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 5 lines]
> Thanks
> Achilles

Reply to this Message