view report in excel

[amna77]

Hi, I have a report in access, but instead of viewing that report in access, I would like to open that as excel speard sheet. I mean after entering my parameters, like start data and end date, etc, when I hit to view report, then it should print that report in excel? can you please help me with this? any example?

Thanks in advance

Amna

 

[dhookom]

Do you know that you can select Tools|Office Links|Analyze It with Microsoft Excel?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.