Select on CheckBox

[Lensmeister]

Can I append another question?

In Access 2003 I have a table and one of othe fields is a checkbox which is either ticked or unticked.

I want to query it to show all the checked ones and ignore all the unchecked ones.

In the Query What must I add to the criteria to show those checked ticked boxes ?

Thanks all.

Lensmeister.

[Stewart Ross]

The field concerned is really a Yes/No type (a Boolean value), represented as a checkbox for data entry.

In the query grid all you need to do is to set the criteria for that field to True. This will restrict the rows to show only those where that field is set to True (the equivalent of checking the checkbox concerned). An example is shown in the attached screenshot.

-Stewart

[NeoPa]

That's an easy one - No ;) Questions need to be kept in separate threads as far as possible. This makes much more sense when searching for problems (most of our users actually use the site that way more than posting questions).

For your technical question though, the simple answer is to add (to the WHERE clause) :

[NameOfField]

Seems too easy I know, but is the most correct way to check boolean values (such as is the case here). A name to work with would have made this easier to follow, but assuming a name of [Selected] (Field in your table), and no other criteria required, the clause would be :

SELECT ...
FROM ...
WHERE [Selected]

[Lensmeister]

Thanks mate .... :)

I've got it going nicely now :)