3.0

Managing Database Records
10 Managing a Database
•
does not end with:
find records that do not have the
Value
entry
at the end of the selected field or records that do not contain
the value entry at all.
This search finds records that do not have
Franich & Halsey
at
the end of an entry in the
Customer
field.
•
contains:
find records that contain the
Value
entry.
This search finds records that have
Franich & Halsey
entered
anywhere in the
Customer
field.
Be careful when selecting
contains
as one of your conditions.
In a search for the value
male
, for example, your search would
include any records that contained the word male. It would,
therefore, also include records for
female
.
•
does not contain:
find records that do not contain the
Value
entry.
This search finds records that do not have
Franich & Halsey
entered anywhere in the
Customer
field.
•
is empty:
find records that have no entry in the selected field.
The
Value
text box is disabled if this is selected.
•
is not empty:
find records that have an entry of any sort in the
selected field.
The
Value
text box is disabled if this is selected.