Exporting/Analyze in MS Excel

T

Terri

When I export or analyze in MS Excel the data type Yes/No
converts to True/False. In the query I have gone to the
field and under properties I have changed on the general
tab; Format to Yes/No and on the Lookup tab: Display
Control to Text Box. With doing this it display the
words "Yes" or "No" however when I go to analyze or export
in MS Excel the Data is displays "True" or "False". What
can I do to correct this other then manually changeing all
the true to yes and false to no.

Thanks,
Terri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top