I have a report in Access that I'm exporting to Excel. The values of 3 calculated fields don't export. They're just blank. Can someone tell me why?
I have a report in Access that I'm exporting to Excel. The values of 3 calculated fields don't export. They're just blank. Can someone tell me why?
Just offhand, causes don't come to mind. You could provide db for analysis. Follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
your previous thread was about exporting a report formatted - is this the case here?
Are you exporting the query?
yes. export the query to excel, the calc'd fields will transfer.
It's a long story but I really want to export via the report. It's weird, I have 3 calculated fields and two of them show in the export and two don't. They are all visible in the report obviously. Other than different formulas they're the same.
I found a workaround. I had to go in and add the calculated fields to the query. It's working now.