Static Page Numbers on Report Printouts

[kornork]

Hello,

I have a large report that I have printed out, and for any changes to that report, I only print the records that have changed. As all of the records go in the same 3-Ring Binder, in a fixed order, I would like to have the page numbers match. For example, printing the full report gives "Page 1 of 308," "Page 2 of 308," etc., but when printing a subset of the records, they say "Page 1 of 51," "Page 2 of 51," etc. when I would like them to say "Page 5 of 308," "Page 6 of 308," etc. according to their order in the original report. If this is not possible, I would at least like to print the record number (according to the fixed order of the report), e.g. "Record 23 of 143."

I have thought about creating a field in the record which would store the page number from the original report (and update it if more records are added), but I can't fully wrap my mind around the solution. Some problems are:
1) I can't seem to store the page# from the report
2) I don't know how I would deal with reports that cover more than 1 (or 2, or 3. . .) pages. Even if I store several page numbers for each record, how do I get the footer for page 1 to print [FirstPage] and the footer for page 2 of the record to print [SecondPage]?
3) I have thought of trying to create a new table with a one to many relationship with the main record table. This might have two fields, foreignkey and page number, and each foreignkey (referring to my main record table) would have several entries, one for each page number. Again, I run into problems.

If anyone has dealt with this before, or has any ideas, I would appreciate any help.

Thanks,
Josh

 

[dhookom]

You could place a prompt or expression in the report like:
=[Enter Starting Page Number] + [Page] -1
This will prompt you for a starting page number and go from there. If you don't want to be asked when running the report, you will have to store the value in a table.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[kornork]

Hmm, I don't think that would do it, as the reports I am reprinting are not sequential. They could be records 6, 31, 80, and 81.

As for storing a value, I'm thinking I may have to do it manually, but that is not desirable, as the number of records may change (and one may be added from the middle).

Thanks for your reply,
Josh