change True/False to Yes/No

[lsyhu]

Hi,

I have a yes/no data type in my Access database. When I use ASP to query it ("Select myFields from myTable&quot, it always report "True"/"False". But I want it to be "Yes"/"No". I hae already choose the format for this field to be "Yes/No" in access, but it did not work. Is there any way to get Yes/No instead of True/False?

Your quick response is greatly appreciated.

Lisa

 

[blom0344]

Hello Lisa,

Try the following (or modify as you wish):

SELECT IIf([yesno]=-1,"YES","NO&quot AS expr
FROM

;


In this case table is called 'table' , the field with the checkbox is called 'yesno' and 'expr' is the new name for the output field for the query.

succes.