Page numbering within a grouping

[NoodNutt]

Hi all

I would like to number each page within a grouping

eg

Report page numbering = Total Pages 7
DestState "QLD" = Pages 1 of 3 to 3 of 3
DestState "NSW" = Pages 1 of 3 to 3 of 3
DestState "SA" = Pages 1 of 1

I have
="Total Pages " &[Pages]
which gives me the total number of pages for the whole report.

I would also like page numbering of the grouping of "DestState".

I tried
="Page" & [Page] & " of " & [Pages]
and placed it in the "DestState" Header but this did not work.

Any suggestion appreciated

TIA
Mark.

 

[fredg]

Hi all

I would like to number each page within a grouping

eg

Report page numbering = Total Pages 7
DestState "QLD" = Pages 1 of 3 to 3 of 3
DestState "NSW" = Pages 1 of 3 to 3 of 3
DestState "SA" = Pages 1 of 1

I have
="Total Pages " &[Pages]
which gives me the total number of pages for the whole report.

I would also like page numbering of the grouping of "DestState".

I tried
="Page" & [Page] & " of " & [Pages]
and placed it in the "DestState" Header but this did not work.

Any suggestion appreciated

TIA
Mark.

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 an unbound control to the Page Footer.
Name this control "ctlGrpPages"

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

3 In the code, change Me!Salesman to
Me![Name of the control used to group by]

 

[NoodNutt]

Fred

That is way cool, thx heaps for the pointer.

Regards
Mark.