Number of Pages in a Report Section

[dch3]

Is there a way to determine the number of pages that a section will span? I
would like to provide a Page 1 of 3 at the section level. The report that I'm
working with has sections that are somewhat isolated from each.

Think of a report that recaps the passenger manifest on flights flown using
the same plane where each section represents a flight. The header gives all
of the plane information, the section provides the flight information an PAX
manifest. While we currently have the report printing at the flight level,
eventually we'll need it to run it at the plane level.

 

[fredg]

Is there a way to determine the number of pages that a section will span? I
would like to provide a Page 1 of 3 at the section level. The report that I'm
working with has sections that are somewhat isolated from each.

Think of a report that recaps the passenger manifest on flights flown using
the same plane where each section represents a flight. The header gives all
of the plane information, the section provides the flight information an PAX
manifest. While we currently have the report printing at the flight level,
eventually we'll need it to run it at the plane level.

Group the report by Section.
Then see:
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]