Not "Y"???

[Bill]

Hi All,

I have a single length text field that is used for entering Y or N for
yes/no. In a query I don't want to return any row where this field has Y
entered, but entering Not "Y" in the QBE returns zero rows. The field in
question will either contain nothing or Y.

I have tried various ways of entering Not "Y" and can't spot why I am
getting the zero return. Any clues please.

Ta.
Bill.

 

[KARL DEWEY]

<>"Y" OR Null