Is Null

[hmongie]

Hello all,

I'm trying to get this to work but is having a few problems. Hope someone can help.

SELECT *
FROM MTL_Log
WHERE (((MTL_Log.AccountingName) Is Null) AND ((MTL_Log.AccountingID) Is Null) AND ((MTL_Log.AccountingDate) Is Null));

I have the above right now. But it's not working right.
I need the statement to pull all the records where AccountingName and AccountingID and AccountingDate are null and also if any of the field is null. Right now, if at least one of the field is filled in, the do not show in my report.

Any ideas on how to get this to where if any of the field is null then the record will show?

 

[Alc]

SELECT *
FROM MTL_Log
WHERE ((IsNull(MTL_Log.AccountingName))
AND (IsNull(MTL_Log.AccountingID))
AND (IsNull(MTL_Log.AccountingDate)));

 

[hmongie]

Thanks for the Post..

Sillie me...

I've tried the statement with OR and it works fine.. now..

I've did it before and it didn't work but now it does.. I probably didn't save the changes somehow.