Convert boolean constant to a number

  • Thread starter Thread starter angelo
  • Start date Start date
A

angelo

How can I convert an intrinsic boolean constant (field
name with a boolean field defined as yes/no) to a number
so that I can use the number in an mathematical
expression in a query?

Examples
"true" or "yes" to -1
"false" or "no" to 0 (zero)
 

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

Calculated Field as Boolean 1
Boolean parameters in query 2
Using a boolean return value from a function as criteria in query 2
Boolean in Query 3
Cast to Boolean 9
Boolean data type mismatch 6
RE: Can a boolean ever be set to null? 0
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top