Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Creating PivotTables - Pg. 383

Analyzing Data with PivotTables and PivotCharts 383 5. In the New Form dialog box, you can start the PivotTable Wizard or use the option Auto- Form:PivotTable. The PivotTable Wizard and the autoform option provide roughly the same level of assistance; using the autoform option will save a few clicks when you set out to create a PivotTable. Select AutoForm:PivotTable, and then select qryProductsByCountry as the PivotTable's re- cord source. Click OK. After Access creates the form, you'll see the PivotTable window and the PivotTable field list, shown here: