a checkbox in a query

[Guest]

i'm wanting to set the user specify if a checkbox is checked or not in a
query, but i'm unsure how to do this. any ideas? the field that has a
checkbox is called "Cleared" and is part of a table called "Data" by the way.

thanks.

 

[[MVP] S.Clark]

A checkbox is typically bound to a Yes/No field, which can have, typically,
one of two values. It will be True or False.

So,

SELECT * FROM TableName where [FieldName]
or
SELECT * FROM TableName where NOT [FieldName]

Other than that, I don't understand your sentence.