How to query YES/No field??

[rickyfong]

Field in table with data type as yes/no. If I create a query with condition to show either 'yes' or 'no' for this field. For the time being, I have to put either "='yes' or '=no' in the condition to accomplish my query. According to my knowledge, I could create a list box filed instead of 'yes/no field to ease the selection criteria, but I want end user to just click either 'yes' or 'no' instead to locate a list of text in list box. Just want to know, for some cases, how to show all results with 'yes' and 'no' using the same query?? Thanks a lot!!

 

[Mile-O]

Use True or False.

 

[rickyfong]

Ok! My problem is that instead of just showing either True or False, I also want to have an option to show all True and False in the same query. Can I have this kind of query!! Thanks!!