Database Reference
In-Depth Information
4
You start specifying filtering criteria for the text you want to find
by selecting an option from the Text Filters list.
TIP
The sort and filter options displayed when you click the arrow to the right of a
field name (or when you click the Filter button in the Sort & Filter group) are deter-
mined by the data type of the field. The PostalCode field is assigned the Short Text
data type to allow for ZIP+4 codes. If you display the sort and filter list for a field that
is assigned the Number data type, the sort and filter list includes Number Filters in-
stead of Text Filters, and different options are available.
6
In the list, click
Begins With
to open the
Custom Filter
dialog box.
The name of the text box is customized with the field name and the filter you chose.
7
In the
PostalCode begins with
box, enter
880
. Then click
OK
to filter the table and
display only the records that match your criteria.