Number Report pages starting over with each record

[Culby]

I have a report generated by a query. The query with find about 1 to 500 records. Each record with vary in length of pages due to a memo field of varying size. I need to print 1 or all of the records but need the page numbering to start over with each record such as Page 1 of 3 then Page 2 of 3, etc.

So far, I have created only numbering that includes all the pages of the report such as Page 1 of 45 and the second record being something like Page 4 of 45, etc.

Does anyone have a solution for this?

Thanks,
Culby

 

[CosmoKramer]

Check out Access help for "Reset page numbers for each group in a report". It gives step-by-step instructions on how to do this.....