HP 95LX - Page 72

Writing Search Criteria
The search criteria determine exactly which records will be found. There are
several different categories of criteria:
Simple searches that seek to match a particular label or value in one field
exactly (e.g. “find all records whose St at. e field is IN”).
Simple searches that seek to match a part of alabel in one field, using wildcard
characters to stand for the rest of the label (e.g. “find all records whose
surname field begin with M”).
Simple searches based on a formula involving one field (e.g. “find all records
whose 1NCOMe field is greater than $20,000”).
Compound searches that match two or more fields simultaneously (e.g. “find all
records whose St. at e field is IN and whose income field is greater than
$20,000”).
Compound searches that match any of two or more fields (e.g. “find all records
whose St at e field is IMor whose 1NCoOme field is greater than $20,000”).
Complex searches involving one or more combinations of the above categories.
Below is an example database and criteria range that will be used to illustrate how
to execute these various categories of searches:
st
Washington WI
Adams IN
Jefferson OR
IN
NY
Madison
Monroe
Cl
add
WO
RS
Tn
ST
SN]
SX
The criteria range is AZ « «C3; the database (i.e. input) range is A6 . .C11.
72
2. ANALYZING INFORMATION