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?