Printing collated reports in Access

[MoDiggity]

I need what turns out to be an 8 page report for each record in my database. I created 3 reports in Access because the format I needed to replicate only allowed 3 pages to fit on the first report, 4 pages on the second report, and 1 page on the 3rd report. Is there a way to lengthen a report so that all 8 pages will fit on it? or can someone help me figure out how to create a command or button button that will print all 8 pages of each record before printing the next record so that the data prints collated?

 

[markphsd]

Try Sub Reports