Problem with selection criteria not working

[mellicks]

I hope someone can help me on this. I've been staring at it until I'm cross-eyed. I am trying to pull information from a database in such a way that either all fields have information in them OR the first three fields are blank, but the rest are filled in. My selection criteria is shown below, but the report is pulling for only the first set of the criteria, nothing after the OR is working and I can't figure out why. There is other selection criteria besides this section, so I put this section in () so it's evaluated together. Any help would be GREATLY appreciated!

((({ActivityIndicator.Number}=1 and
{ActivityIndicator.Category}=11 and
{ActivityIndicator.Classification}=1) and

({PayCodeIndicator.Number}=5 and
{PayCodeIndicator.Category}=11 and
{PayCodeIndicator.Classification}=1) and

({PayCodeIndicator_1.Classification}=1 and
{PayCodeIndicator_1.Category}=3 and
{PayCodeIndicator_1.Number}=1) )  

OR

((isnull({ActivityIndicator.Number}) and
isnull({ActivityIndicator.Category}) and
isnull({ActivityIndicator.Classification}))and

({PayCodeIndicator.Number}=5 and
{PayCodeIndicator.Category}=11 and
{PayCodeIndicator.Classification}=1) and

({PayCodeIndicator_1.Classification}=1 and
{PayCodeIndicator_1.Category}=3 and
{PayCodeIndicator_1.Number}=1) )
)

Thanks so much for looking!

 

[lbass]

(
(
(
isnull({ActivityIndicator.Number}) and
isnull({ActivityIndicator.Category}) and
isnull({ActivityIndicator.Classification})
)and
(
{PayCodeIndicator.Number}=5 and
{PayCodeIndicator.Category}=11 and
{PayCodeIndicator.Classification}=1
) and
(
{PayCodeIndicator_1.Classification}=1 and
{PayCodeIndicator_1.Category}=3 and
{PayCodeIndicator_1.Number}=1)
)
) or
(
(
{ActivityIndicator.Number}=1 and
{ActivityIndicator.Category}=11 and
{ActivityIndicator.Classification}=1
) and
(
{PayCodeIndicator.Number}=5 and
{PayCodeIndicator.Category}=11 and
{PayCodeIndicator.Classification}=1
) and
(
{PayCodeIndicator_1.Classification}=1 and
{PayCodeIndicator_1.Category}=3 and
{PayCodeIndicator_1.Number}=1
)
)
)

You must check for nulls first--otherwise, once a field is referenced it is treated as if it is non-null.

-LB