I have a Access report that is based on a single query and runs fine. BUT when the user opens the report and right clicks to export to excel, the header fields show up but no data. the details export fine. If you right click and export to Word, everything shows up. I tried adding a button with docmd.OutputTo and got the same results.
Any thoughts why the header data is missing?
the source data query pulls the header and details in a single result.