Microsoft® Office Access™ 2007 Plain & Simple

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