Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1

Filtering Information in Tables 853


A list of criteria appears.

You can specify criteria for the text you want to find.

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 determined by
the data type of the field. The PostalCode field is a Text field 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 instead of Text Filters, and different options
are available.


  1. In the list, click Begins With.


The Custom Filter dialog box opens.

The name of the text box is customized with the field name and the filer you chose.


  1. In the PostalCode begins with box, type 880. Then click OK.


Access filters the table and displays only the records that match your criteria.
Free download pdf