If then statement question

[Rita D via AccessMonster.com]

Hello,

I have a simple question. I have a TRUE/FALSE field in one of my tables. When
I build a query and export the results to an Excel spreadsheet, that
particular field all it says is "TRUE" or "False" How can I change it to say
"YES' or "NO" instead?
I tried if =true then "yes", but it gave me an error.

Rita

 

[George Nicholson]

In your query:
FieldName: IIf(TableName.[FieldName],"Yes","No")

HTH,