Is it possible to print a self-contained 3-page report per record?

[pretzelz]

Hi,

I have a small school database setup. Each pupil has a record containing different information.

I can design a report to include the information I want, but I don't seem to be able to print each record as a self contained (multple page) report.

For example, a report for one pupil might contain:

"page 1" school name. pupil name. year.


"page 2" pupil social information
"page 3" pupil grades


Each page of the report should be numbered page 1,2 and 3. Then I want the database to print the next report in the same way, using the information from the next record.

At the moment, i have designed a page 1, page2 and page3 layout with fields from the table. But the database then continues to print page 4, 5, 6, 7, 8, 9 etc with the following records.

Thus, how do you print just a self-contained multiple page report?

Many many thanks, I'm sure it must be an easy fix somewhere, seems like an obvious request.

[pretzelz]

Sorted! It seems by writing out my own question, I came up with an answer! So for anyone else looking to address this problem...

Take out the automatic page label.
Optional: take out header etc information, just leaving your DETAIL section available only.
Create the content for your first page layout.
Add a page break marker (select page break from toolbox and click where you want this)
Then design page 2
Add page break marker beneith
Design page 3
Add page break marker beneith
Then add a simple static label on your three pages saying Page 1 Page 2 and Page 3 and you're complete!

Voila! Preview the report, and you have a "3 page report" containing information just for 1 record. Nice.