Boolean Display Values in Union Query (1 Viewer)

[msp]

I have created a union query, The query works correctly the only problem is that one of the fields types in the query is Boolean, The query now displays “-1”and “0” rather than “Yes” and “No”. I understand why it is showing “-1” and “0”. However is there a way I can get the query to display the values “Yes” and “No”. I was hoping to dump the query in to a .xls spreadsheet to send to the users. It would be easier to explain a Yes/No value rather then “-1”and “0”.

 

[FoFa]

In place of you YES/NO column try NewName: IIF([MyCol],"Yes","No")