Chapter 12. Grouping and Summarizing Data
The reports you learned about in Chapter 11 provide a complete listing of the records in the data set. In this chapter, you will learn how to create reports that group and summarize data, distilling down a large amount of data into a manageable, meaningful report.
Understanding Grouping and Summarizing
Group Report Results
Sort Report Results
Count Records
Add an Aggregate Function
Summarize a Datasheet with a PivotTable
Add Aggregate Functions to a PivotTable
Group and Ungroup PivotTable Content
Clear a PivotTable Grid
Switch a PivotTable to a PivotChart
Understanding Grouping and Summarizing
When you have a lot of ...
Get Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
