Step 1: Create a query.Step 2: Open the query in PivotTable view.Step 3: Add data fields to the PivotTable view. Add row fields. Add column fields. … Step 4: Add calculated detail fields and total fields to the view. Add calculated detail fields.

How do you pivot in access?

1. Step 1: Create a query.
2. Step 2: Open the query in PivotTable view.
3. Step 3: Add data fields to the PivotTable view. Add row fields. Add column fields. …
4. Step 4: Add calculated detail fields and total fields to the view. Add calculated detail fields.

How do I create a pivot table in Access 2007?

1. Open the table, go to the Views group, click the arrow, and select Pivot table.
2. Click the Field List button, if the field list is not visible (Figure A).
3. Click and drag the ShipCountry field to the row area (Figure B).