run a query on if a checkbox is checked

[ivalum21]

I am drawing a blank on how I run a query on if a checkbox is checked.

I have a table of people, and in that table is a column that specifies if they are a "Leader", if it's checked, they are a leader.

I want to run a query on all the "Leaders" in the table...how do i do this?

thanks for any help you can give me.

 

[grande]

SELECT * FROM tblPeople WHERE chkbox = -1

Hope this helps.

-------------------------
Just call me Captain Awesome.

 

[ivalum21]

Okay, I just figured it out...

In design view of your query, under criteria you put:

=Yes

That will display all the checkbox's that are checked.