Sub-Totals

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.

Data wrote:

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...49&Product=acc
--
Marsh
MVP [MS Access]

Thanks for the information and resource!


-----Original Message-----
Data wrote:

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
--
Marsh
MVP [MS Access]
.