Null fields

[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

 

[Danny Lesandrini]

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

 

[Marshall Barton]

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.

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).

 

[Candace]

That was perfect. Thanks so much!

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

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