True/False Boolean problem

  • Thread starter Thread starter Bytecafe
  • Start date Start date
B

Bytecafe

I am trying to run a select query and in this query I
have a field that is Boolean, so it shows up as -1 or 0
in the query (and on the report).

Well, I would like to know what state to use to get True
or False in my query?

Thanks,
 
-1 is True / On (actually, non-zero values are treated as
True)
0 is False / Off

If you want to see True/False rather than -1/0, use the
Format Property of the relevant Field in your Query.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top