When you want to summarize information in a lengthy list using complex criteria, use the PivotTable to simplify your task. Without the PivotTable, you would have to manually count or create a formula to calculate which records met certain criteria, and then create a table to display that information. Once you determine what fields and criteria you want to use to summarize the data and how you want the resulting table to look, the PivotTable and PivotChart Wizard does the rest. Access comes with a control on the Toolbox to insert a Pivot Table in a data access page.
Insert a PivotTable in a Data Access Page