"Exporting reports to Excel" problems...

[Finchmore]

Hi Guys, I have a weird problem that's just cropped up and am hoping someone can help.

I've been running some simple reports for the past year in Access which I then export to Excel. These have been running fine and just show a sum total of sales for a list of stores. However I have just started using these reports on a PC with MS-Office 2000 and the sum values now don't export. The list of store names is still exporting fine but the sum values are missing. I have tried completely re-creating the report and the query it's tied to but to no avail. Has anyone else come across this sort of problem before and has anyone got a solution?!

Many thanks...

 

[Blorf]

In most cases, by default, when you export a report by using menu options (I could be wrong about this), it exports based on the query or table the report is based on, and not the report.

This can be solved by exporting using code instead of menu options.

How are you running the export?

ChaZ

Ascii dumb question, get a dumb Ansi

 

[Finchmore]

Hi ChaZ, thanks for this...

Yep, I understand what you're saying about the export being based on the query and as far as I can see the query seems fine. I need to use the report because I want to just get summary values for each store and unfortunately I have no SQL coding skills therefore I've used the report wizard to get what I want. After that, I then just highlight the report and choose the "Export" option. It just seems so strange that it's now not working with MS-Office 2000. V bizarre!