Calculated Field as Boolean

  • Thread starter Michael Suttkus, II
  • Start date
M

Michael Suttkus, II

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?
 
J

John Spencer

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
 
Top