Singling out data

Hi Amie

It is best to do this in the software that created the database.

So in Access:

1. Create a Query based on the table that has the missing data. In your example it sounds like a Employee or Costumer table

2. The query should have at least an ID and name field (so as to identify the record) and every field that you suspect is missing data (the Phone and Contact Details field in your example)

3. In the Query

a. write the words Is Null in the Criteria line of the Phone field

b. write the words Is Null in the Or line of the Contact Details field

NB. This way the query will show ALL missing Phone and Contact Details. If both had been put in the Criteria row it would only show records where BOTH fields were missing.

4. Save and Run the query

Hope this helps

Carlos