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
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