Criteria / expression help

[MissLotus]

I have 4 fields that is a Yes/No format eg x1, x2, x3, x4.
What I am trying to achieve is that if anyone of x1,x2,x3 is a "Yes" and x4 is a "NO" to be filtered and displayed.
I think I am putting the expression wrong because I have it as x1-3 "Yes" and x4 'No", it seems like all the records are appearing.

[Dal Jeanis]

SELECT MyField1, MyField2, MyField3
FROM MyTable
WHERE x1 AND x2 AND x3 AND NOT x4;

or

SELECT MyField1, MyField2, MyField3
FROM MyTable
WHERE MyTable.[x1] = True AND MyTable.[x2] = True AND MyTable.[x3] = True AND MyTable.[x4] = False;