Page numbering Quandary

[ITbeast]

Hello,

For a project that I'm working on I print daily reports and at the completion of the project we will print final cumulative reports. What is required is that each day the page number is increased. So on day one we printed the report and it spanned pages 1-3, then on day two the report spans pages 4-9 and so on. On the final report those record locations (page and line number) have to be maintained.

What my issue is:
I can store the page number after the report is ran just fine, so the next report starts on the next page number. My only problem is that sometimes if the last record of the day happens to be on the last line of the last page, it will generate a final blank page. Obvisouly this screws up my page numbering system.

Any bright ideas?

 

[PaulF]

I'm not sure if you're printing the detail section on the blank page or not, but if you aren't, you can create a variable that increments by 1 each time the detail section prints (OnPrint Event), and then when the report closes, you can store the value of this variable to a table. Just ensure that you dim the variable in the General Declarations section and not in one of the subs, so it can be used in more than one sub event.

PaulF