While you're pondering the question, maybe be more explicit about the possibilities you really want to include. The question posed does cover
WHERE "A" AND "B" AND "C"
vs
WHERE "A"
OR "B"
OR "C"
but what about the need for
WHERE "A" AND "B"
OR "A" AND "C"
OR "B" AND "C" ?
The mixing of AND with OR complicates things to the point where a vba solution is often used.
EDIT: I am fairly quick on the keyboard, yet am beaten to the punch again.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.