Output Query to Excel

K

Kathy Webster

I have aYes/No field in a table. When I output it's select query to Excel,
the field is printing out as True/False. How can I make it print as "Yes" or
"No" instead?

TIA,
Kathy
 
D

David F Cox

you could alter the field in the design grid of the select query to :
my_TF: IIF(my_Yn,"True","False")
 
T

TedMi

Actually, you want this:
myYN: IIF(my_TF, "Yes", "No")
where my_TF is the actual name of the yes/no field in your table.
 
Top