Merging many RPTs in Access

[jsramos]

I am trying to create a phone directory for my neighborhood. I would like to list all in alphabetic order and then again by street. There are 7 streets in my neighborhood. Some streets are really long and have many homes. Some streets are short and only have a few homes. I have a total of 8 reports. I want to produce a directory using all 8 reports. I don't want page breaks in between the reports. I want them all to flow together and I want the page breaks to occur where they need to - according to my page size. How to I create one big report or document that includes many reports?

 

[dhookom]

You can try create a new, blank report. Then add your other reports to the detail section as subreports. Keep in mind that any "PAGE" sections from your subreports dissappear when used as subreports. You can get around this by add a new primary sorting and grouping level to each subreport and set the field/expression to =1. Display this group level header section. Open the properties for the =1 group header and set the Repeat Section property to Yes. This is your new page header for the subreport.

Duane
MS Access MVP