set up a query to find only records that are empty in one field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up an Access Database. I would like to be able to set up a query
which finds results where a particular field is empty. I tried to use
Expression Builder, but cannot seem to get it working. Can anyone give me the
correct expression for this?
 
In the Criteria row under this field in query design, enter:
Is Null
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find values that are not equal 1
query several fields 5
Query Field Using Other Fields in the Query 3
Counting records in a query 9
Criteria: Empty field 1
Empty field not showing as a result of a query 2
Getting request that a query have a destination field 3
Testing for null 4

Back
Top