Page numbers-Easy!

Posted on 2001-06-06
Last Modified: 2010-05-18
I know that I've seen this answer before but I can't seem to find it.  I need to reset the page numbers after every group.  (i.e., group 1 pages 1 of 4, group 2 pages 1 of 5, etc.)  Any help would be appreciated.
Question by:luceze_99
LVL 12

Accepted Solution

DRRYAN3 earned 50 total points
Comment Utility
Taken straight from A97 help ...

Reset page numbers for each group in a report

Create a macro that resets page numbers

1 Create a macro that uses the SetValue action to change the Page property to 1.


Decide if the page number will appear in the page header or footer, and then use the following values for the SetValue action arguments.

Location of page number     SetValue arguments
Page header     Item:  [Page]Expression:  0
Page footer     Item:  [Page]Expression:  1

2 Save and close the macro.

Modify the report

1     Open the report in Design view.
2     Create a text box for the page number in the page header or footer if you haven't already done so.


3     For the first-level group header and footer, set the following properties, depending on where the page number appears.

If the page number appears in the page header, set the following properties.

Section     Property     Setting     Purpose
Group header     ForceNewPage     Before Section     Starts each group on a new page.
Group footer     OnFormat     Name of macro you created in the first procedure     Resets the page number to 1 for the new group.
If the page number appears in the page footer, set the following properties.

Section     Property     Setting     Purpose
Group header     OnFormat     Name of macro you created in the first procedure     Resets the page number to 1 for the new group.
Group footer     ForceNewPage     After Section     Starts each group on a new page.
Note   The Employee Sales by Country report in the Northwind sample database resets the page number for each country. To view this report, open the Northwind database in the Samples subfolder of your Office folder. In the Database window, click the Reports tab, click Employee Sales By Country, and then click Design. For information on opening Northwind, click  .

Author Comment

Comment Utility
That's close enough.  I tried to do the set value function on the [pages variable as sum [page]] but it didn't work.  That's a trivial detail any way.  Thanks for your help.

Expert Comment

Comment Utility
The solution provided by DRRYAN3 works for resetting the page number within each group, but it does not reset the Total # Pages for that group.

For example, I have 100 pages in the report and 25 pages per group.  Each page footer should read "Page 1 of 25".  Instead, all 4 grouping sections read "Page 1 of 100".

Please help.  I find that the solution offered by DRRYAN3 is simplest because it utilizes Access' easy MACRO setup, versus complicated VB and Midules.

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now