How do I query for blank fields?

B

BereaSue

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?
 
S

Steve Schapel

BereaSue,

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

Ted Allen

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
 
Top