Export Report to Excel

[cathalfarrell]

Hi All,

I have a report that opens with filter criteria based on drop downs options on a form.

Is there anyway to export that report to excel by using a button? I can export the original report based on the query but this is not filtered based on the criteria selected from the form.

This is probably something really simple but I'm a bit new to access and learning as I go along.

Any help is greatly appreciated.

Cathal

 

[eepok]

In access 2003, you used to be able to right click on the displayed report and select "export to excel". The results were mixed and were highly dependent on whether or not you prepared your report in format that could easily be translated to a spreadsheet.

In access 2007, the function or option does not exist. You cannot export a report to excel any more. Why? I wish I knew.

 

[cathalfarrell]

In access 2003, you used to be able to right click on the displayed report and select "export to excel". The results were mixed and were highly dependent on whether or not you prepared your report in format that could easily be translated to a spreadsheet.

In access 2007, the function or option does not exist. You cannot export a report to excel any more. Why? I wish I knew.

Thanks for you feedback