Format true/false

Licass · Mar 13, 2006

i´d like to format the true /false db results field output to yes/no

Jon Spivey · Mar 13, 2006

Hi,
Assuming MS Access
select iif(YesNoField <> 0, 'Yes', 'No') AS YesOrNo
from table