This need to be clarified step by step…
1. AND, OR
From your previous post, with
WHERE (Completed="No" OR Completed="" AND !Completed="Yes") AND (priority="" OR Priority="" OR due="" OR Due="")
I deduce this: “I want all pages not completed AND at least one of the fields (priority OR due) empty”. I.e, !Completed AND (!Priority OR !Due).
But seems you want all pages with at least of one of the fields (“Completed”, “Due” or “Priority”) empty (or not completed). In this case you need to use OR in all conditions:
WHERE Completed = "No" OR !Completed OR !Priority OR !Due
This works?
EDIT: sorry, I read your post by parts… and I misreading your second query…
My tests:
Queries and results:
