Microsoft Office Tutorials and References
In Depth Information
To create a PivotTable using a query:
1. Open the Navigation Pane, open the qryInvoicesByItem query datasheet to dis-
play the 172 records in the query, close the Navigation Pane, right-click the
qryInvoicesByItem tab, and then click PivotTable View to switch to PivotTable
view. See Figure 8-28.
Figure 8-28
PivotTable view for the qryInvoicesByItem query
drop areas for the
fields you select
PivotTable Field
List pane
select and click to place
fields in the drop areas
PivotTable view
To create a PivotTable, you click a field in the PivotTable Field List pane to select it,
and then drag it to one of the four drop areas—row, column, filter, or totals/
detail—or click the Add to button at the bottom of the PivotTable Field List pane
after selecting one of the four drop areas in the list to the right of the Add to
button.
Sarah wants to use the InvoicePaid field as the column field, the City field as the
row field, the InvoiceDate field as the filter field, and the InvoiceAmt field as the
detail field.
2. Click InvoicePaid in the PivotTable Field List pane, click the arrow on the list box
to the right of the Add to button in the PivotTable Field List pane, click Column
Area in the list, and then click the Add to button. Access places the InvoicePaid
field and its field values in the column drop area.
3. Repeat Step 2 to add the City field to the row drop area, the InvoiceDate field to
the filter drop area, and the InvoiceAmt field to the totals or detail drop area. The
four selected fields are bold in the PivotTable Field List pane and appear as compo-
nents in the PivotTable. See Figure 8-29.
 
Search JabSto ::




Custom Search