How do I set up criteria to show only the fields that are blank?

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

Guest

I'm trying to run a Query in Access and would like to set the criteria to
show the "blanks" from a table. Basically I'd like to see where I have
incomplete information - how can I do that?
 
in the criteria under your column, put one of the following...

= ""

or

Is Null

Rick B
 
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

Blank Fields in NOT Null Query Criteria 5
#error - Blank 3
How do I include the blank fields in a Query? 2
Criteria in a Querie 8
Criteria Question 2
Null fields 3
Entering criteria from form 2
How to retrieve dates that meets a criteria using Query? Exp Build 1

Back
Top