Creating a Grouping Report with the Report Wizard

This section shows you how to use the Report Wizard to create a grouping report based on data in the Products and Suppliers tables of the Northwind Traders sample database. (Like the Form Wizard, the Report Wizard allows you to create reports that contain data from more than one table without first creating a query.) This report displays the quantity of each specialty food product in inventory, grouped by product category.

To create an inventory report, you modify the basic report created by the Report Wizard. The process of creating a basic report with the Report Wizard is similar to the process that you used to create a form in Chapter 12, "Creating and Using Forms." An advantage of using ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.