Calculating Beginning and Ending page numbers

[sabraham]

I have a database that is a summary report of documents in the chain of title for real estates. When we present the report, we hard copy the documents and stack them together and number the pages. I need to include the beginning and ending page for each document in the Access Report. In other words if the first document has 5 pages, the Access Report for that record would need to show Pages 1-5. If the second document has 3 pages, it would need to show Pages 6-8.



One of the fields in each record in the database is the number of pages in that document. I do this in Excel by having two columns, one for the beginning page number and the ending page number. On the first record in the spreadsheet the beginning number is 1. I add the number of pages in the document to the beginning number and subtract 1. On the second record to calculate the beginning page number, I add the ending page number from the line above plus 1. To calculate the ending page number, I add the beginning page number from the current line and subtract 1.

I need to do this in Access.

Any Suggestions?

[RuralGuy]

It is not real clear to me how you have things organized in Access. Is this for a report or a form? Is it a Table of Contents? More details would be helpful.

[sabraham]

This is a report and yes it is like a a table of contents.

[RuralGuy]

Interesting problem. The report generator makes several passes before it actually starts to print so you may be able to use the Format Event to determine the page numbers. Did you plan for this TOC to be at the beginning of *this* report?