Total Column Sum for Multiple pages on Multiple Pages

  • Thread starter Thread starter Chris21788
  • Start date Start date
C

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
 
Chris21788 said:
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.)
Click to expand...


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