Access.2007.VBA.Bibl..

After making the selection, the report shows only Gourmet Lanchonetes records (Figure 1.23).

FIGURE 1.23

A report filtered by a Customer value.

PivotTables ......................................................................................................

If you need more advanced interactivity, you can make a PivotTable based on the same

qryNorthwindAllquery. In Access 2007, the process of creating a PivotTable has been simpli-

fied; just select the data source query or table, then, as depicted in Figure 1.24, select PivotTable

from the More Forms menu of the Forms group in the Create tab of the Ribbon.

Storing and Displaying Data in Access 1