Yes/No user input criteria don't work

coffent

New member
Local time
Today, 09:50
Joined
May 9, 2012
Messages
2
I have an Access query with a Yes/No field. If I set the criteria for the field as "Yes" the query correctly displays all records with that field checked (i.e., = Yes), and similarly with "No". However if I try to allow user input by setting the criteria field either to [Enter Yes, No, or *] or to Like [Enter Yes, No, or *] then no records are displayed no matter whether Yes or No is entered. (Entering * displays all records.) What am I doing wrong?
 
That worked! Thanks - I should have thought of that myself.
 

Users who are viewing this thread

Back
Top Bottom