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 Home->Sort&Filter->Filter