Exporting a yes/no field

[lowanam1]

When I export a query into excel the yes/no fields that I have read as true /false instead of yes/no. Is it possible to get to read yes/no after being exported into excel?

Also when I export currency into excel it goes out to two decimals places even tho the default setting in acces is at 0. Is there a fix for this as well?

Any help would be greatly appreciated.
Thank you

 

[John Big Booty]

How are you doing the Export? File Menu option or using the SendObject method? and what version of Access are you using?

 

[lowanam1]

Im using the shortcut option to export in 2007. thank you

 

[boblarson]

Set up your field in your query like this:

NewFieldNameHere:IIf([OriginalFieldNameHere]<> 0, "Yes", "No")

And for your other field, the currency one you can use

NewFieldNameHere:FormatCurrency([OriginalFieldNameHere], 0)

 

[lowanam1]

In the query design view, I would put that in the field row?

 

[pr2-eugin]

Yes, It will be the row..

 

[lowanam1]

Thank you!