Export Report To Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vensia - 17 Jan 2006 10:59 GMT

Dear all,

Access has built-in function to export report into Excel.
But for report which has grouping, the result is messed.
Is there any better solution for exporting report to Excel ?
Thanks.

Vensia

Reply to this Message

AccessHelp - 17 Jan 2006 20:04 GMT

You can create a command button which links with a select query. Whenever a
user clicks on the button, it will run the query and export the info into
Excel.

> Dear all,
>
[quoted text clipped - 4 lines]
>
> Vensia

Reply to this Message

joshblair - 17 Jan 2006 22:52 GMT

AccessHelp,

I have the same question.

If I add a command button to a report, I can't click it because the
cursor is a magnifying glass to zoom in and out.

Are you suggesting that we add a command button to a form rather than a
report?

Thanks for the help,

Josh Blair

Reply to this Message

AccessHelp - 17 Jan 2006 23:03 GMT

Yes. Then name your command button so that the users know what it's for.

> AccessHelp,
>
[quoted text clipped - 9 lines]
>
> Josh Blair

Reply to this Message