Page numbering by grouped data

[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

 

[fredg]

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

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]

 

[Marshall Barton]

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]

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