How do I query for blank fields?

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

Guest

I maintain a large database with names and addresses for mailings. In my
"home address" field, many records are blank -- I don't have addresses for
these people. I need to find out how many people do not have addresses on my
database. I know I need to build a query, but I don't know what criteria to
specify in order to produce my no-address list. Any ideas?
 
BereaSue,

Put this in the criteria of the Home Address column in your query design...
Is Null
 
Hi,

To get just the number of records, if you type the query in SQL view, it
would be:

SELECT Count(*) FROM YourTable WHERE YourAddressField Is Null;

IF you want to see all of the detailed records, just create a normal select
query and type Is Null in the criteria row beneath your Address Field (if
using the query builder).

HTH, Ted Allen
 
Back
Top