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!

Number of Pages per record (not report) 1

Status
Not open for further replies.

TimTDP

Technical User
Feb 15, 2004
373
ZA
How can I determine the number of pages a record uses in a report, and show these on each page.

For example, a report may be 7 pages long, but only consists of 2 records - 1 record consisting of 2 pages and the other 5 pages.

I want to place the following on each page:
Record 1; Page 1 of 2
Record 1; Page 2 of 2
Record 2; Page 1 of 5
Record 2; Page 2 of 5
Record 2; Page 3 of 5 .....
 
TimTDP
Assuming that you are starting a new page when a new record occurs, and have a Group Footer, you might try this...

1. Put an unbound text box, probably a running sum, in the Group Footer. The purpose of the text box would be to count the pages in that group.
2. Put an unbound text box in the Page Footer. That text box will reference the text box in the Group Footer.
3. After you are sure that it does what you want it to do, make the text box in the Group Footer invisible.


Tom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top