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
 

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

How do I query for blank fields? 2
#error - Blank 3
Access Skip address field if previous field is blank 2
How do I find which forms have a particular field which is blank? 1
counting Null fields 3
How to exclude certain records 7
Count text values in a Access Field 0
query criteria expression for blanks 7

Back
Top