Exam 77-424: Microsoft Access 2013 5.0 Create Reports 5.3 Format a Report: Filter the Data With a Field

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