TechTrain "Just-In-Time"
  Select Program Program Access Steps 1 - 8 of 8
  Topic Filtering and Sorting
  Select Objective Objective Filter
   
 

Filter by Form
   Step  1
We will filter by more than one criteria.

 




Filter by Form
   Step  2
Click on Filter by Form button

 




Filter by Form
   Step  3
Enter the data you wish to filter on.

We will filter on Last Name = Baker




Filter by Form
   Step  4
Click on the Apply Filter button.

The results of filtering by Form using "Baker" as the filtering criteria are shown below.




Filter by Form
   Step  5
To filter on more than one criteria:
Choose Records | Filter | Advanced Filter/Sort


 




Filter by Form
   Step  6
Drag down the fields you will use as criteria to the filtering grid.

You can click on the drop-down arrow and select the name(s) of the fields to filter on.




Filter by Form
   Step  7
Enter the values to filter by:
We are using OR. Notice: Criteria are not on the same line.


We will filter by lastname = Cook OR zip code > 50000.
> stands for greater than





Filter by Form
   Step  8
The information displayed should look similar to the example shown below.

Note: All zip codes are greater than 50000 except for Clara Cook.




 
   
Copyright © 1999-2010
Additional help available at techtrain@techtrainteam.com.

TechTrain Home