Review the Filtered Report

6. Try it: Review the Filtered Report

This Report displays 17 out of 401 records in tblMovies when the Filter is set for 2000.

 

Made You Look: In the Sort&Filter Group there is a button that will Toggle the Filter. Toggle means that it will turn the Filter on or off so that you can see the data with or without the Filter.

 

In this example, there are 17 records that match the Filter criteria 2000. There are 401 records when the Filter is toggled off.

 

Try This, Too: Clear the Filters

Go to Home->Sort&Filter->Advanced.

Click on Clear All Filters.

 

Keep going...

Exam 77-885: Microsoft Access 2010

5. Designing Reports

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

Home->Sort&Filter->Filter->Advanced