search records using a boolean data field as criteria

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

Guest

I would like to be able to search (or query a table) for records that have a
boolean field set to either "yes" or "no".
The boolean fields seem not to be searchable. Maybe in the field properties
it could be possible to make it a searchable field.
I haven't been able to do that. Does anybody know how to do this?.
 
Dear Albert:

I prefer to use = 0 for false, <> 0 for true. If the value is boolean
and you are working in Jet, the value is defined as -1 for true, but
any non-zero value is defined as meaning true. Also, other databases
use values other than -1 for true, but it seems all use 0 for false,
so there is no penalty for testing <>0 to mean true, and this is more
portable if the need ever arises.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top