Adding a Filter to a Form

You can define a filter as:

• Filter by Selection
• Filter by Form
• Advanced Filter definition facility

Filter by Selection

This feature enables you to see all the rows containing a value matching the one in the Datasheet Grid.

1. Select a complete value in a field.
2. Only rows with completely matching values are displayed.
3. Select the value Washington in the State column.
4. Click Filter By Selection.
5. If the filtering data you need is in several contiguous columns, click the first column.
1. Hold Down the shift Key and click the last column to select all the data.
2. Click Filter By Selection to see only those rows, which match the data in all the columns you selected.

Before selection

After selection

Filter By Form

To see rows which meet any of the several criteria:

1. Click the Filter By Form.
2. A datasheet appears without any data.

3. If you have not previously defined filtering criteria, go to the bottom of window for Look For tab and Or tab.

4. To define criteria for specific columns, select a value from the drop down list or type in search criteria.

5. Each drop down list shows you all the unique values available for each field. This makes it easy to pick values and perform an exact comparison.

Criteria for City and State

After applying the criteria using Filter By Form