User manual

Finding and sorting information 3-5
For information about omitting related records, see “Finding all
records except those matching criteria” on page 3-6.
Finding records that match multiple criteria
You can narrow or widen your search by using more than one
criterion.
Records matching all criteria specified ( logical AND search )
To narrow your search, enter criteria in as many fields as needed to
make your request specific, then click Find.
Example: to find all people named Smith who work in Sales, type
Smith in the LastName field and Sales in the Department field.
Records that match at least one of the sets of criteria, but not
necessarily all ( logical OR search )
To widen your search, enter criteria in the first request. Choose
Requests menu > Add New Request. Enter the second (set of) criteria.
Continue adding requests for each (set of) criteria, then click Find.
Examples:
1 To include customers in New York and customers in Paris in the
found set, type New York in the City field in the first request, then
type Paris in the City field in the second request.
1 To include companies with more than 100 employees and
companies with more than $100 million in assets, type >100 in
Number of Employees in the first request, then type >100,000,000
in Capitalization in the second request.
1 To include 6th grade students who are in Honors Algebra and 7th
grade students who are in Honors Geometry, type 6 in Level and
Honors Algebra in Course in the first request, then type 7 in Level
and Honors Geometry in Course in the second request.
Records that match one set of criteria but not another
To narrow your search by excluding records that meet specified
criteria (for example, to find vendors in New York state that are not
in New York City), see “Finding some records while omitting
others” on page 3-7.
Deleting and reverting requests
To delete a request, go to the request you want to delete, then choose
Requests menu > Delete Request.
E154Invoice ID
AlvarezName
Item ID Item
I100
Computer
I202 Desk
I153 Lamp
I229 Bookcase
I448 Chair
Find request
E153Invoice ID
TangName
Item ID Item
I202
Desk
I443 Long table
I153 Lamp
I288 Round table
I100 Computer
Invoice ID
Name
Item ID Item
Computer
E152Invoice ID
DurandName
Item ID Item
I384
Swivel chair
I554 Panels
I288 Round table
I100 Computer
I448 Chair
Records in master file