MS Access Querie Criteria

[madness]

I have a field identified as Yes/No. In my query, how can I set the criteria to that field as either the Yes or No condition? Thanks! http://www.PCGuide.com/ubb/smile.gif

[geebee76]

Hi madness!

I hope i've understood you're question correctly so here goes http://www.PCGuide.com/ubb/smile.gif
i'm assuming that you are running the query in design view.
All you need to do is in the criteria box for the yes/no field is type =yes and run the query. Only the records that have been selected will be displayed. Likewise typing =no will only display the records that haven't been selected.

Hope this helps!

[madness]

Thanks geebee! Ever have one of those days where the simpliest things escape you? http://www.PCGuide.com/ubb/tongue.gif

[geebee76]

Yeh about 364 of them a year http://www.PCGuide.com/ubb/smile.gif

Glad to be of help