Use the Report: Filter  

A Filter narrows the focus of a Report and only returns the records that meet the criteria. This example uses the data to select only the movies that were released in a particular year, not all years. 


5. Try it: Filter the Records in a Report

The Report is still opened in Layout View.
Select a Column: Years.
Go to Home->Sort&Filter.
Click on Filter.

What Do You See? The Filter should be available by the Field for Year.


Try This, Too: Select Only One Filter

By default, there should be check mark in Select All. Clear that check mark and all of the Filters will be cleared as well.


Select a Filter: 2000.

Click OK. Keep going..

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.6. Sort and filter records for reporting: Use the Filter Command