I am not able to export Yes/No Fields from a report to an Excel spreadsheet, they just don't transfer over. Is there a fix for this?
Thanks!
Cindy
I am not able to export Yes/No Fields from a report to an Excel spreadsheet, they just don't transfer over. Is there a fix for this?
Thanks!
Cindy
Import the excel sheet as is. It will have text values...yes/no.
Afterward, in the table,add a field that is Boolean,y/n.
run an update query to mark the Boolean field where of all text =YES
I'm going from Access to Excel - nothing transfer to Excel from the report that has the Yes/No field on it from the table. I need to know how to get the field to export/show in Excel.
Thanks!
Change it to a text field and in the record source for the report add a new field :IIf([Fieldname]=True,"Yes","No") or whatever values you want to display.