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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page Numbers

Status
Not open for further replies.

SamDemon

Technical User
May 28, 2003
171
GB
Hi everyone.
slight problem i have a report that is run from one of my queries. This query displays all the information stored within the 'Company Details' table. However i run the query so that it displays everyones details, this results in the report being over 200 pages long. What i want is for after the trading names section for the pages to start back to one of .... For example the first company might be 1 of 3, where as the company after might be 1 of 2. Instead it shows as 1 of 258 and 4 of 258.
Any suggestions, not even sure if you can do it.
 
In a report create a text box with this value
="Page " & [Page] & " of " & [Pages]

Jim DeGeorge [wavey]
 
I'll try it thanks.

It's just common sense, shame sense isn't common!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top