How to set total page number for each group?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.. I have reset the page number for each group in a report. However, I am
unable to calculate the total page number for each group.
For example: For two groups, the first group got one page, second group got
three pages. I want to set the page number to appear for first group: page
1/1. For second group: page 1/2 and page 2/2. Pls help. Thanks.
 
Hi.. I have reset the page number for each group in a report. However, I am
unable to calculate the total page number for each group.
For example: For two groups, the first group got one page, second group got
three pages. I want to set the page number to appear for first group: page
1/1. For second group: page 1/2 and page 2/2. Pls help. Thanks.
Click to expand...

See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm

Things to make sure of:
1) Add a control to the page Footer that computes [Pages], i.e.
= [Pages]
You can make this control not visible if you wish.

2) Add an unbound control to the Page Footer.
Name this control "ctlGrpPages"

3) Paste the code into the Page Footer Format event.

4) In the code, change Me!Salesman to
Me![Name of the control used to group by]
 
I tried the method. However, the result came out as page 1 of 1 and page 2 of
2 when there is two pages in the group. The result should be page 1 of 2 and
page 2 of 2. Pls help. Thank you =)

fredg said:
Hi.. I have reset the page number for each group in a report. However, I am
unable to calculate the total page number for each group.
For example: For two groups, the first group got one page, second group got
three pages. I want to set the page number to appear for first group: page
1/1. For second group: page 1/2 and page 2/2. Pls help. Thanks.
Click to expand...

See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm

Things to make sure of:
1) Add a control to the page Footer that computes [Pages], i.e.
= [Pages]
You can make this control not visible if you wish.

2) Add an unbound control to the Page Footer.
Name this control "ctlGrpPages"

3) Paste the code into the Page Footer Format event.

4) In the code, change Me!Salesman to
Me![Name of the control used to group by]
Click to expand...
 
Back
Top