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)
 

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

Boolean parameters in query 2
Calculated Field as Boolean 1
Boolean data type mismatch 6
Cast to Boolean 9
Unable to set query parameter 17
Find groups of records where a Boolean field is False 5
expression with True of False showing up as -1 or 0 5
Using a boolean return value from a function as criteria in query 2

Back
Top