Calculated Field as Boolean

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

Guest

I have a query containing several calculated fields that produce true/false
as answers. These are reported to the user as numbers (-1 or 0). I would
like them to report as boolean (yes/no) fields so that they visually match
adjacent boolean fields, but I can't find any ready way to do this. Does
anyone have any advice?
 
You can set the format property of the column in the query grid

Set it to
"";"No";"Yes"

Or you can change your calculations to return Yes or No instead of the
boolean values.

IIF(Calculation,"Yes","No")

That show blank for postive numbers; No for Negative numbers; Yes for 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

Cast to Boolean 9
Boolean parameters in query 2
Convert boolean constant to a number 1
Query Help - How to total checked boxes? 2
Format a calculated field in a query 7
True/False Boolean problem 2
Boolean field not recognizing 0 1
Boolean data type mismatch 6

Back
Top