Count up check boxes

[virgosam20]

I was just wondering if there is any way that I can create a query to find all of the records which have a tick box checked.

There is a tick box on each form and I want to know what I type in the 'Criteria' box is Query Design so that I can quickly and easily search for all those which are checked.

I know that in a normal query, to search for a particular object you can type it in (e.g. 'Mugs' - will find all the records under the name of 'Mugs' when typed under the right heading) but i'm unsure of what to type in under the 'Target' heading to make it find all those which are checked.

Any ideas. . .

 

[stopher]

You can type any of the following in the criteria:
true
yes
-1
on

hth
Chris

 

[virgosam20]

Thanks!

Knew it was simple. Just didn't know exactly what to type in