Total Column Sum for Multiple pages on Multiple Pages

[Chris21788]

Ok, I created a report, based on a query. I need to know
how to get a total column sum, for all the pages, and put
it at the bottom of every page. (Ex. page 1 total =
$5.00 & page 2 total = $10.00...I want it to display at
the bottom of every page, "Total = $15.00", instead of
$5.00 on one page, and $10.00 on the other.) Can anyone
help? Thanks, Chris

 

[Marshall Barton]

Ok, I created a report, based on a query. I need to know
how to get a total column sum, for all the pages, and put
it at the bottom of every page. (Ex. page 1 total =
$5.00 & page 2 total = $10.00...I want it to display at
the bottom of every page, "Total = $15.00", instead of
$5.00 on one page, and $10.00 on the other.)

Here's an article that shows how to do that.

http://support.microsoft.com/default.aspx?scid=kb;en-us;132017&Product=acc

While that article is for early versions of Access, it is
far superior to the same subject for A2K, which uses an
unreliable technique.