Take Control: Producer (Page 1) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Filter the Report

Before you go, there's one more function that all of the Microsoft Office programs have: Filters. Word, Excel, Outlook and Access use filters very effectively on tables, forms and reports.

 

Try This: Filter the Report

Open the customer label report in Print Preview. Now, click on the data that you want to use in the filter. In this example, the cursor was placed on the city named MyTown.

 

Go to Home-> Sort and Filter.

 

 

When you click on Selection, you can choose Equals, Not Equal, Contains (Like) and Does Not Contain (Not Like).

Home->Sort and Filter->Selection
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 5. Presenting and Sharing Data 

  5.2. Filter data   5.2.3. Filter data within reports