[Access 2k3] Make multiple reports

[Jean-Didier]

Hello

First, sorry for my english... I'm french.

I'm a begginer in Access. I want to make a query based on something like this :

It's a table with our employees with :
First Name, Last Name, ID, Equip's name, and lot of data from the working time for each day like Staffed Time, Time in AUX, Time in meeting....

I want to make a macro who can send by mail an excel workbook.
I want this macro export table data every day on each worksheet, who are been created by equips name (1 workbook, lot worksheets)

Can someone help me ?
I dont know where is the beginining... A single query ? A multiple query ? Only by SQL ?

 

[HiTechCoach]

Hello

First, sorry for my english... I'm french.

I'm a begginer in Access. I want to make a query based on something like this :

It's a table with our employees with :
First Name, Last Name, ID, Equip's name, and lot of data from the working time for each day like Staffed Time, Time in AUX, Time in meeting....

I want to make a macro who can send by mail an excel workbook.
I want this macro export table data every day on each worksheet, who are been created by equips name (1 workbook, lot worksheets)

Can someone help me ?
I dont know where is the beginining... A single query ? A multiple query ? Only by SQL ?

I would have to say only by VBA code and Excel Automation.

See: Export Data To Excel