O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required