Exporting yes/no columns to excel

[jackie77]

Hi all

I'm not sure if this is the right forum to post on but here goes,

I am exporting a query from access 2007 to excel 2007 and my yes / no columns are changing to true / false in excel is there any way to make these appear in excel as yes / no instead?

regards

Jackie

 

[GaryPanic]

you could put a text box into your qry with if x = true then Yes else no, sort of thing...

 

[jackie77]

Hi gary thanks for the reply

I'm still new to access so not too sure how to go about doing this?

Regards

Jackie

 

[CraigDolphin]

I think he means adding a field, not a textbox, into the query you want to export. Something like:

MyYesNoField: Switch([YourYesNoFieldNameHere]=-1,"Yes",[YourYesNoFieldNameHere]=0,"No",isnull([YourYesNoFieldNameHere]),Null)

 

[jackie77]

Thanks for the replies, I have set it up and it works great cheers!!