Click to view attachmentSorry for the second post but I got nowhere on the first go-around. This time I have added some screen shots. And now the problem:
I have created a query that has all the information that I am using in my report. When I render query to pull up one record everything works fine depending on the record the report could have 1 to 3 pages and it prints out great including the page count eg. 1 of 3. "see attached file pr2-print-pre-view-like-it-should-be.png" The problem I'm having now is it when I run the query and brings back multiple records now the report will only produce the header on the first page and the page header on the pages that follows. "see attached file print-pre-view-of-report-that-is-wrong.png" That would be fine if I was only needing one record at a time in said query, however I now have 20 to 30 records being returned in the query and now the report is not doing what I would like it to do. It is producing the report for all the records as one report and only placing the report header on the first page and page header on all the following pages and the page count is like 1 of 42.
What I am trying to do is get the report to produce a report header for each record in the query and if there were to be a second page the the page header would go on the second or third page and the count would be 1 of 3. So I would end up with 20 separate 2 or 3 page reports and not 1 60 page report. This time I included the design view as well see pr2-design-view.png please ignore the green errors in the design view screen shot this PC that I used to create the shots in not linked to the tables.
Again any help with this would be greatly appreciated.