True/False Boolean problem

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,
 
V

Van T. Dinh

-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)
 
Top