Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Page Numbers 1

Status
Not open for further replies.

vwhite

Programmer
Oct 4, 2001
87
AU
Does anyone know if there is a built in Access function to count the number of pages within a section of a report. (Or some other work around?)

I know "Page " & [Page] & " of " & [Pages] shows the page number and total page numbers of the report but i need to show page no of the current section and total page numbers of section.

Cheers
 
What do you mean by "section"? Do you mean a group of records??
 
I believe that is the question.....I have the same one..

How do I set me report to generate Page # of Pages for each group???

My report is grouped by country, and each country is stored in its own location. So I need to have each country displayed with its total page count. I have checked some of the other forums and can't get anything to work yet... "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." Albert Einstein. [spin]

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com
 
Check out my replies to the following thread: thread703-18458. I think this is what you're looking for......
 
thanks mate! - that was eactly what I was after

the only problem I'm having now is that I can't get it to display on the first page of the report.

I have 2 groupings
[Area]
[TestType]

The group page display is in the TestType Group Footer and I have the ForceNewPage Property set to After Section in the TestType Group Footer.

I need to have a new page for each TestType within an area and the display the page count for each TestType within an area.

At the moment the page count displays on every page but the first.

cheers...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top