B
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.
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.