Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

742

FIGURE 20.32

This query returns more detailed information than I’ve been using.

This query returns the following information: company name, order date, order ID, product name,

unit price, and quantity for the period from January 1, 2012, to March 31, 2012.

The initial report design to contain this data is shown in Design view in Figure 20.33. This rather

complex report includes a group based on the order ID for each order placed by the company, as

well as a group based on the company itself. This design enables me to summarize data for each

order during the quarter, as well as for the company for the entire quarter.

FIGURE 20.33

Notice how narrow the records in this report are.