a checkbox in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top