Output Query to Excel

  • Thread starter Thread starter Kathy Webster
  • Start date Start date
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
 
you could alter the field in the design grid of the select query to :
my_TF: IIF(my_Yn,"True","False")
 
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.
 
Back
Top