Null Value in multiple Fields

[bdmoran]

Hi all - I have a table includes the following fields:

In time
Out Time
Actual IN
Actual Out

The problem is that sometimes employees forget to clock in or out which results in null values in the above fields.

I need a query that will pull data if one of these fields is null.
I know I can use the OR criteria for two fields but I was confused about what to do when there are more than two fields.

Hope you can help.

 

[PHV]

What is the problem ?
SELECT * from yourTable WHERE [In time] IS NULL OR [Out Time] IS NULL OR [Actual IN] IS NULL OR [Actual Out] IS NULL

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MazeWorX]

Then don't pay them for those days and they'll never forget again

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[TheAceMan1]

How are ya bdmoran . . .

[blue]PHV[/blue] has the solution ... [blue]MazeWorX[/blue] has the [purple]fix![/purple]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jsteph]

Or...since *any* NULL poisons any calculation making the result Null:

If (field1 + field2 + field3 + field4 + ....Fieldn) is null THEN

--Jim

 

[bdmoran]

Hey guys - Sorry for the delay but this is all set. Thanks!