Amie has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Singling out data
On my database how can i single out all the people with no details under their company/telephone number or contact details so i have a list of who'S details I will need to update?i.e they are currently blank
Is it best to do it in Excel or Access.
Singling out data Using Is Null
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
