- Open the report you want to use as the main report in Design view.
- Make sure the Control Wizards tool in the toolbox is selected.
- Click the Subform/Subreport tool in the toolbox.
- On the report, click where you want to place the subreport.
- Follow the directions in the wizard dialog boxes.
When you click the Finish button, Microsoft Access adds a subreport control to your report. It also creates a separate report that is displayed as the subreport.
Add an existing report to another report as a subreport
- Open the report you want to use as the main report in Design view.
- Press F11 to switch to the Database window.
- Drag a report or datasheet from the Database window to the section you want the subreport to appear in on the main report.
Microsoft Access adds a subreport control to the report.