I have a report that I built in Access 2002. I built it with the report wizard, but then went into design mode and added a extra information which was calculations off the existing fields in the report (these calculated values are not pulled in the original query). So the report looks great and performs as expected, but when I export it to Excel I lose all of the extra fields that I added (and of course all of the formatting). All that it exports is what was originally created in report wizard. Is there any way to get the rest of the report, that I worked so hard on creating, over to Excel? After reading the previous posts on the limitations of the report export I'm expecting the worst but hoping for the best. Thanks.
Jeff