Query question?

[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

 

[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

 

[Marshall Barton]

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.

 

[hmm1979]

It worked that way. Thanks so much!!!

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