Page numbering within a grouping

  • Thread starter Thread starter NoodNutt
  • Start date Start date
N

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.
 
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.
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 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]
 
Back
Top