Analyze with MS excel

[romack]

Hello,
Help,
I am trying to export reports to excel. As I have just upgraded to office 2000 I am now using access 2000(not so updated as it is now 2004). Before there was no problem, now when I export, all of my values that are sums in the report will not show up in the excel sheet. All other values export with no problem.
Any ideas??????????

Thanks in advance for any help,
Bob

 

[MMSantiago]

Sounds like your sums are being calculated in the report itself but you're exporting the query on which it is based, which does not contain any sums. Try calculating your sums within the query itself and it should export properly. Hope this helps.