Creating a Subreport

An Access database often has a number of relationships between tables. In the Northwind sample database, for example, Suppliers make Products, which are part of Orders placed by Customers. When two tables are in a one-to-many relationship, you can create a report based on the contents of the table on the "one" side of the relationship and add a subreport displaying related records from the table on the "many" side of the relationship. The Customers and Orders tables are in a one-to-many relationship (they have the Customer ID field in common), so you could create a report listing every customer and add a subreport displaying all orders placed by the current customer.

Add a Subreport

  1. Open a report in Design view.

  2. Click the Subform/Subreport ...

Get Microsoft® Office Access™ 2007 Plain & Simple 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.