Query Filter

[CodeCracker0291]

Ok, what I would like is on my query. I have Lease and Insurance on my customers. Basically what I want is a list of the customers who doesn't have a Yes, Yes (yes insurance, yes lease) but I also don't want it to show me the N/A for they are "Not Applicable" lol.
Thanks,
CodeCracker0291

 

[WayneRyan]

Code,

How many fields is this?

If one, the criteria is:

<> "Yes"

If two, the criteria is:

Not in ("Yes", "N/A")

for both fields.

If it is an AND then both on same line,
If it is an OR then "staircased"

Wayne