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
 
Back
Top