Incorporating Subreports

Reports, like forms, can include subreports. Unlike the Form Wizard, however, the Report Wizard offers no option of automatically creating reports that include subreports. You can add subreports to reports that you create with the Report Wizard, or you can create subreports from blank reports, as shown in the preceding section, "Working from a Blank Report."

Adding a Linked Subreport to a Bound Report

If a main report is bound to a table or query as a data source, and the subreport's data source can be related to the main report's data source, you can link the subreport's data to the main report's data.

Figure 15.17. The rptMonthlyCategorySales report in Print Preview.

To add and link the rptMonthlyCategorySales ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.