Microsoft Office Tutorials and References
In Depth Information
Filtering Records
AC 155
To Use Advanced Filter/Sort
In some cases, your criteria may be too complex even for Filter By Form. You might decide you want to
include any client for which the postal code is 80330 and the amount paid is $0. You also may want to include any
client whose amount paid is greater than $20,000, no matter where the client is located. Further, you might want to
have the results sorted by name. To fi lter records using complex criteria, you need to use Advanced Filter/Sort as in
the following steps.
1
Click the Advanced button on the
Home tab to display the Advanced
menu, and then click Clear All
Filters on the Advanced menu to
clear the existing fi lter.
Client Form tab
Click the Advanced button on the
Home tab to display the Advanced
menu a second time.
Toggle Filter button
Click Advanced Filter/Sort on the
Advanced menu.
Expand the size of the fi eld list
so all the fi elds in the Client
Table appear.
Include the Client Number fi eld and
select Ascending as the sort order.
Include the Postal Code fi eld and
enter 80330 as the criterion.
Client Name fi eld
Postal Code fi eld
Amount Paid fi eld
Include the Amount Paid fi eld
and enter 0 as the criterion in
the Criteria row and >20000
as the criterion in the Or row
(Figure 3–21).
sort order for
Client Name fi eld
criterion for
Postal Code fi eld
criterion for
Amount Paid fi eld
Figure 3–21
Search JabSto ::




Custom Search