2011

Table Of Contents
Select an operator.
To use wild-card characters, select the LIKE operator. For example, to
list only those streets that begin with the letter C, select the LIKE
operator and enter C% in the Value box. Wild-card characters can be
used only with string values. For information on wild-card characters,
refer to the documentation for your database system software.
Enter a value or click to select from the list of possible values.
After setting your criteria, click Add.
The conditions you set appear in the SQL Filter list.
4 To add additional conditions, select AND or OR. Create and add the new
condition.
5 Click OK.
The Data View displays only those records that match the filter.
You can clear all filters. In the Data View, click Records menu Clear Filter.
Quick Reference
(Data View) Clear Filter
Eliminates all current filters and requeries the database
In the Data View: Records Clear Filter
Menu
Clear Filter
Icon
(Data View) SQL Filter
Displays only records that match conditions you specify
In the Data View: Records SQL Filter
Menu
SQL Filter
Icon
Table Filter dialog boxDialog Box
1232 | Chapter 8 Analyzing Data