Multiple criteria in filter 2

[Hyun]

I'm trying to create a continuous report in Access97 where if a certain group of fields are null, then they will be filtered out and not appear on the report. I was able to use the Filter Property to filter out records with only one criteria by using

IsNull([Field1]) = False

But I need something like

IsNull([Field1]) = False AND IsNull([Field2]) = False AND IsNull([Field3]) = False

Alas this does not work. I think it's because I'm using the wrong syntax. Any ideas on how to resolve this will be greatly appreciated.

 

[jflachman]

You're close. If you want to filter out only records where ALL items are NULL, use this:
[tt]
((IsNull([Field1]) = False) AND (IsNull([Field2]) = False) AND (IsNull([Field3]) = False))
[/tt]
If you want to filter out records where ANY item is NULL use this:
[tt]
((IsNull([Field1]) = False) OR (IsNull([Field2]) = False) OR (IsNull([Field3]) = False))
[/tt]
Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt