Query question?

H

hmm1979

I am using Access 2007 and I have a table tblCustomer that lists customer id,
name, address, city, state, zip, contact first, contact last, telephone
number, and fax numbers for each customer. I have 25 records but some records
are missing information in various fields.

Question: How can I run a query to show the customers that have missing
information?

Note: I tried running a query using "Is Null" in the Or criteria row for
each of the fields but I am not getting any results??

HELP!! PLEASE!!

Marie
 
S

Smartin

I am using Access 2007 and I have a table tblCustomer that lists customer id,
name, address, city, state, zip, contact first, contact last, telephone
number, and fax numbers for each customer. I have 25 records but some records
are missing information in various fields.

Question: How can I run a query to show the customers that have missing
information?

Note: I tried running a query using "Is Null" in the Or criteria row for
each of the fields but I am not getting any results??

HELP!! PLEASE!!

Marie


If you put all your "OR" criteria in one row you will see that they
are really separated by "AND"s in the query SQL view. To test if any
one of the fields is null, you need to stagger the OR's vertically,
something like this (please view in fixed width font!):

Field: Address City State
Table: tblCust tblCust tblCust
Sort:
Show: X X X
Criteria: Is Null
Or: Is Null
Or: Is Null
 
M

Marshall Barton

hmm1979 said:
I am using Access 2007 and I have a table tblCustomer that lists customer id,
name, address, city, state, zip, contact first, contact last, telephone
number, and fax numbers for each customer. I have 25 records but some records
are missing information in various fields.

Question: How can I run a query to show the customers that have missing
information?

Note: I tried running a query using "Is Null" in the Or criteria row for
each of the fields but I am not getting any results??


That's the right criteria, but it needs to go in a separate
row for each field. The criteria should end up looking
like:

Criteria: Is Null
Or: Is Null
Is Null
and so on.
 
H

hmm1979

It worked that way. Thanks so much!!!

Marie

Smartin said:
If you put all your "OR" criteria in one row you will see that they
are really separated by "AND"s in the query SQL view. To test if any
one of the fields is null, you need to stagger the OR's vertically,
something like this (please view in fixed width font!):

Field: Address City State
Table: tblCust tblCust tblCust
Sort:
Show: X X X
Criteria: Is Null
Or: Is Null
Or: 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

Top