HP 95LX - Page 71

To search a database:
1. Open the worksheet containing a database with a criteria range (see pages 72-
73). Make sure it meets the requirements listed above.
2. Prepare the criteria range:
* In the second row of the criteria range, enter your search criteria
below the relevant field names (see below for more information about
writing search criteria).
* Be sure to erase anything below the first row in the criteria range
that doesn’t belong with your current criteria.
3. Press (MENU), (Dlata, (Query. You will see three ranges listed. If all three are
proper for the current search, you can skip ahead to step 5. Otherwise, proceed
to step 4.
4 Change the ranges as follows (do just the ones you need) :
Input —Press Input, type in the range of the database, including the first
row—which contains the field names—and press (ENTER). This range
will remain as the default until you change it—handy for later
searching.
Criteria press (Clriteria, and type in the range of cells corresponding to
the criteria range you created in step 2. This range will be the default
until you change it—handy for later searching.
Out. put —if you wish to extract (copy) the records you find during the search
to a separate list, you must designate an output range. If you just
wish to have the found records highlighted, you can skip the output
range. If you want the output range, press (output, type in the range
(making sure that it is currently blank), and press (ENTER).
5. Ifyou have designated an output range, press (Ejxtract. If you simply desire to
have the information highlighted, press (Flind and then step through the
matching records using the arrow keys, or to end the viewing.
Statistics and Databases 71