Sub-Totals

[Data]

Is it possible to have a subtotal of each page on a report?

Example: Page 1 has 10 lines and then a page break, Page 2
has 10 lines and another pagebreak and then the last page
has 10 items and the grand totals.

What I need to do is to have the 10 records on page 1 add
up in the footer, have the 10 records on page 2 add up in
the footer (not to include page 1's total) and finally end
with the grand total on page 3.

Is this possible to do?

Thanks in advance.

 

[Marshall Barton]

Is it possible to have a subtotal of each page on a report?

Example: Page 1 has 10 lines and then a page break, Page 2
has 10 lines and another pagebreak and then the last page
has 10 items and the grand totals.

What I need to do is to have the 10 records on page 1 add
up in the footer, have the 10 records on page 2 add up in
the footer (not to include page 1's total) and finally end
with the grand total on page 3.

Here's an article that explains how to do that:
http://support.microsoft.com/default.aspx?scid=kb;en-us;296249&Product=acc

 

[Data]

Thanks for the information and resource!

-----Original Message-----



Here's an article that explains how to do that:
http://support.microsoft.com/default.aspx?scid=kb;en- us;296249&Product=acc