Query a Check Box

[breslinc]

If I have a check box in a form, and I want to sort all records with that box checked, what do I put in the criteria box in a query? I tried YES but it lists all the records 3 times. I really need some help in this.

Thanks in advance
Beginner Access 2000 Developer

 

[CosmoKramer]

I'm a little unclear with what you are looking for. If you want your query to return only records where that field is checked, then Yes or -1 will work in the criteria field. If you want to return all records, but sort them so that all checked records are at the top, then set the Sort to Ascending with no criteria specified......

 

[gusbrunston]

Hi:

I think you need &quot; <>0 &quot;

Hope this is helpful. Gus Brunston An old PICKer, using Access2000.