How do I query for blank fields?

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

Guest

I have a large database with residential info on it. I'm trying to determine
how many records on the database have no "home address" listed, in other
words, how many records have the "home address" field blank. What criteria
expression do I use for "no record"?
 
BereaSue,

Put this in the criteria of the Home Address column in your query design...
Is Null
 
Back
Top