True/False = Yes/No

[jasonso]

Hello all,

When exporting a table to excel, is there any way to have access/excel show all entires that say TRUE to say yes and FALSE to say No?

I've created a function that automatically exports a portion of my database to excel and then sends it to a pre-determined group of recipients. I need it to show the value as YES rather than TRUE etc.

Any thoughts?

I've attached a screenshot of what I want to change.

 

[odin1701]

How are you doing the export?

In a query or SQL you could do soemthing like:

IIf([fieldname] = "TRUE", "YES", "NO")

 

[jasonso]

Well I'm using a query to gather the info and using a macro to export and send it.

I've attached another screen of both my query and macro....
With regards to your last response, where would I input that expression? In criteria? Forgive me...I'm new to Access and everything I know is self taught.

; )

Sorry for the quality of the screenshots..damn 100kb upload limit....

 

[evanscamman]

Put this in the 'Field' setting of your query:

iif([YourFieldNameHere],"Yes","No")

 

[jasonso]

SUCCESS!

Thank you both for your help! I would have never thought of that!