Access: Research Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Home-> Sort and Filter ->Advanced ->Filter by Form

Advanced Form Filters

What Do You See? The Form Filter has several new tabs in the bottom left corner. This Form Filter asks you to Look for the data by applying a filter to any of the fields.

 

Memo to Self: There are two different tabs on the bottom of the form filter: Look for and Or.

 

Start with the Look for tab. When you select filters on this page, they are added together with the AND operator.

 

If you add another filter to the OR tab, then the form filter uses the Look for filters OR the ones on the Or tab.

 
 

 

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

  5.2. Filter data   5.2.4. Filter data within forms