Database Reference
In-Depth Information
For each field, you can select a value from the list or enter a value. When you have finished
defining the filter values, click the Apply Filter button to display only the records that con-
tain the specified values.
Using Filter By Form on a table that has only a few fields, such as the one shown in the pre-
ceding graphic, is easy. But using it on a table that has a few dozen fields can be cumber-
some, and it is often simpler to find information in the form version of the table. Using Filter
By Form on a form replaces the form with its Filter By Form version, which has a blank box
for each field.
In the filter form for a form, clicking a text box displays an arrow that you can use to display a list
of that field's unique values.
In any field, you can select filtering criteria from the field's associated list of unique values,
or you can enter the criteria you want. If you know only part of the value you are looking
for, you can use the asterisk wildcard character to represent the character or string of char-
acters you don't know. For example, to filter out all the records with
Philip
,
Phillips
,
Phillip
, or
Phillips
in the LastName field, you can enter
Phil*
. Access then converts your entry to
Like
“Phil*”
, which is the correct format, called the
syntax
, for this type of criterion
.
SEE ALSO
For information about wildcards, see the sidebar “Wildcards” following this topic.
If you want to enter alternative criteria to those you entered on the Look For page of
the filter form, use the Or page. Clicking the Or tab at the bottom of the form displays
another form with blank fields so that you can enter alternatives for the same fields.
