Null fields

  • Thread starter Thread starter Candace
  • Start date Start date
C

Candace

Hi There,

I am trying to generate either a Query or a Report that shows all fields
that are Null. There are 3 columns in question, Staff Name, Hours, and
Month. Some of the fields are blank in all 3 but there are some where its
just the staff name missing or the hours. When I try to use IsNull it
returns only the records that are blank in all 3.

Please let me know how to proceed.

Thanks,

Candace
 
Candace, wouldn't it just be something like this ...

SELECT * FROM tblYourTable
WHERE [Staff Name] IS NULL
OR [Hours] IS NULL
OR [Month] IS NULL
 
Candace said:
I am trying to generate either a Query or a Report that shows all fields
that are Null. There are 3 columns in question, Staff Name, Hours, and
Month. Some of the fields are blank in all 3 but there are some where its
just the staff name missing or the hours. When I try to use IsNull it
returns only the records that are blank in all 3.
Click to expand...


Put the Is Null criteria on different rows in the Criteria
list (that's why the row under Criteria is labeled Or).
When the criteria is all on the same row, they all must be
true (i.e. And).
 
That was perfect. Thanks so much!

Danny Lesandrini said:
Candace, wouldn't it just be something like this ...

SELECT * FROM tblYourTable
WHERE [Staff Name] IS NULL
OR [Hours] IS NULL
OR [Month] IS NULL

--
Danny J Lesandrini
(e-mail address removed)
www.amazecreations.com



Candace said:
Hi There,

I am trying to generate either a Query or a Report that shows all fields
that are Null. There are 3 columns in question, Staff Name, Hours, and
Month. Some of the fields are blank in all 3 but there are some where its
just the staff name missing or the hours. When I try to use IsNull it
returns only the records that are blank in all 3.

Please let me know how to proceed.

Thanks,

Candace
Click to expand...
Click to expand...
 
Back
Top