Create a subreport

Microsoft Office Access 2003

  1. Open the report you want to use as the main report in Design view.
  2. Make sure the Control Wizards tool Button image in the toolbox is selected.
  3. Click the Subform/Subreport tool Button image in the toolbox.
  4. On the report, click where you want to place the subreport.
  5. 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.

Show Add an existing report to another report as a subreport

  1. Open the report you want to use as the main report in Design view.
  2. Press F11 to switch to the Database window.
  3. 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.