specifying search criteria

  • Thread starter Thread starter Ryan Young
  • Start date Start date
R

Ryan Young

I'm trying to specify some search criteria in a query in which I want to
search based on my Complete field being checked or unchecked (to basically
say yes or no). What string do I need to enter in the Complete field's
search criteria to show complete (checked) entries?
 
If you are talking about a Yes/No field then zero and minus one are the
values. Minus one ( -1) equals yes.
 
Set the criteria to True (or -1 which is the same thing) if you want to
select checked or False (0) if you want to select unchecked for the Boolean
Field.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Date search query 0
Query based on Check Box 1
Using Search Criteria Eg: "Like 2005)*" 7
Filter subform from combo unbound text box 3
Dynamic search criteria from an array? 1
Help Please creating Lookup/Filter Macro 1
Date Range Search 2

Back
Top