It's not
uncommon for a field to have no data. A user may have
skipped the field or left it blank because there was no
value for the field at the record's time of entry. For
example, phone numbers may be missing for some prospects in
your Prospect table.
To find
all prospects whose phone number field contains no data,
follow these steps:
-
Create a query using the Prospect table.
-
Select the Name and Phone Number fields from the
Prospect table for the query.
-
Enter Null in the Criteria cell of the Phone Number
field. (Access automatically replaces the entry with Is
Null.)
