Page numbering by grouped data

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

Guest

I have a report of donations by family. Some families have 1 page others have
multiple pages. When I put in the page numbering to print page X of Y it
says page 1 of 300 (total pages) instead of the desired page 1 of 1 or page 1
of 3, whatever is correct for the family. I've searched here on page
numbering and couldn't find something that might lead me in the right
direction.

Here is the code I have now: ="Page " & [Page] & " of " & [Pages]

I'd appreciate any advice in this matter.

TY,

Kelvin
 
I have a report of donations by family. Some families have 1 page others have
multiple pages. When I put in the page numbering to print page X of Y it
says page 1 of 300 (total pages) instead of the desired page 1 of 1 or page 1
of 3, whatever is correct for the family. I've searched here on page
numbering and couldn't find something that might lead me in the right
direction.

Here is the code I have now: ="Page " & [Page] & " of " & [Pages]

I'd appreciate any advice in this matter.

TY,

Kelvin
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]
 
KLP said:
I have a report of donations by family. Some families have 1 page others have
multiple pages. When I put in the page numbering to print page X of Y it
says page 1 of 300 (total pages) instead of the desired page 1 of 1 or page 1
of 3, whatever is correct for the family. I've searched here on page
numbering and couldn't find something that might lead me in the right
direction.

Here is the code I have now: ="Page " & [Page] & " of " & [Pages]
Click to expand...


Here's an article on that question:
http://support.microsoft.com/kb/841779/en-us
 
Back
Top