To create a PivotTable view of a query, open the query in Datasheet view and then choose
View, PivotTable View. As shown in Figure 38.9, you can drag columns from the Field List
to the “drop zones” on the PivotTable canvas to build the PivotTable.
Figure 38.9
Access PivotTables
work much like their
Excel counterparts.
Access PivotTables are a powerful way to analyze data interactively, just as they are in Excel.
Excel PivotTables are easier to use for simple lists; use Access PivotTables when you need to
combine data from multiple sources for analysis.
Troubleshooting
Tracking Down Data Integrity Problems
I applied a validation rule to ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.