Tick Box in a query

[Guest]

Hi

One of the columns in my table contains tick-boxes. Some tick-boxes are
ticked and some are not.

I'd like to run a query that only displays tick-boxes that are ticked.

Could someone help me do this?

Thanks

 

[Al Campagna]

Adam,
That depends on what type of check box they are.
In an Option Group, you would assign them a numeric value, so a criteria
would be...
= 5..... or ... = 3 (whatever value you gave them)
As a standalone Boolean field (True/False), the criteria would be...
True (or -1) or False (or 0)

If you need clarification, please describe the check boxes in detail,
with examples...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Guest]

The check boxes are simply boolean ( true/false ) fields. All you need to do
in your query is set the criteria for that field to true or false depending