Access 97/2000: Placing a Subreport in a Report

You can add a subreport to any section of a report. In Design view, irrespective of which section you added the subreport to, you see the subreport control just once. But when you preview or print the report, you might find that the subreport repeats once for each record, group, or page.

The reason for the repetition is that the section that contains the subreport determines the number of times the subreport is displayed in the report. For example, if you add a subreport to the detail section of a report, the subreport will repeat once for each record.

To get the results you want, follow these guidelines while adding a subreport to a report.