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!

Start a report page number from a number other than 1

Status
Not open for further replies.

JulieS

MIS
Nov 23, 2000
48
CA
Hello,

I have many many charts that I want to compile into one report. The problem is that access only allows the report to be 22" long (thus I cannot copy all the charts into it).

So, I'm thinking the only solution is to copy as many charts as I can into one report, so I may have a total of 3 long reports. The problem when trying to make it look like it is one document once printed is that i have no way of incrementing page numbers.

For instance, in the page footer, i coded

Me.Page = 3

however, this does not increment (all the pages are 3, and rightly so).

Any ideas or another way of approaching the problem??

Thanks,
Julie
 
JulieS,

Use a text box with the control source set to:

="Page " & ([Page]+2)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top