Advanced Search, Test Three Fields To Be Rejected

[jnpurdy]

I created an advanced lookup and it did not perform the way I expected.  Thought I understood Boolean, but maybe not.  Here's the lookup:

(	Type	Field Name	Operator	Value	)	And/Or
	Contact	Last Results	Starts With	Selected For Project A		And
	Contact	E-Mail	Contains Data	Nothing		And
	Contact	Time Zone	Starts With	Central		And
(	Contact	e-Mail	Does Not Contain	OptOut		Or
	Contact	ID-Status 2	Does Not Contain	OptOut		Or
	Contact	ID Status	Does Not Contain	OptOut	)	End

The above fails.

When I changed the last three rows to And, then the test worked.

In other words, do not select a contact if e-Mail doesn't contain "OptOut".  The same for ID-Status 2 and for ID-Status.  

Why does changing the last three to "End" ?

Many thanks

[jnpurdy · Accepted solution]

Yep, it's been at least 60 years since taking a class in Boolean logic.

Thank you.

[Roy_Laudenslager]

The issue was that you were chaining OR negative conditions. In other words the first does not contain statement included all that didn't meet that condition. the second did the same thing which meant that it likely included everything the first statement was intended to exclude. Remember that AND is the same as NOR.

[jnpurdy · Accepted solution]

Yep, it's been at least 60 years since taking a class in Boolean logic.

Thank you.