• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

3. Reports > 3.7. Create a Page Total

3.7. Create a Page Total

Problem

Access allows you to create a group total in the group footer on a report or a report total on the report footer, but you can’t find a way to create a page total in the page footer. You understand that this problem doesn’t come up too often, but for your report you could really use this element. Is there a way to sum up values over a single page?

Solution

It’s true that Access allows aggregate calculations only in group or report footers. You can, however, easily create page totals using two simple macros. This solution demonstrates this technique and shows how to add this capability to any of your own reports.

To create page totals for your own reports, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint