Yes/No export appearance

  • Thread starter Thread starter HopyMSU
  • Start date Start date
H

HopyMSU

Access 2007 question and probably a simple one at that.

I work with a database that I export to excel on a daily basis. We use
a number of "Yes/No" check boxes on our main table. When I export this
table, these checkbox fields appear as "True" or "False." Is there a
way to change this so when it exports it shows as "Yes" or "No" ?

FYI: In the fields' properties, under general, it says "Yes/No"
instead of "True/False" or "Off/On."

Thanks,
A
 
Use a calculated field in place of the real field in the query that you
export, and use the Format function in the expression for that calculated
field:

SELECT Field1, Field2, Field3,
Format([FieldName], "Yes/No") AS NewFieldName,
Field5, Field6
FROM TableName;
 
Back
Top