Using a tick box as a criteria

[mattpearcey]

I have a field that is a tick box. I want to run a query based on the criteria being those records that are ticked. And thus not showing those which havent been ticked. How do i write the criteria for this in the design view? Thank you for your help already.

Matt Pearcey

 

[Philly44]

If I understand you right you mean Chek Boxes? If so then just type in either Yes or No. Yes means ticked and No means not ticked.