Multiple Reports from refreshing dataset

[dczeman]

I receive a weekly excel spreadsheet that contains data for all employees in my company. Employees are grouped into buckets. I am interested in creating a separate report for each employee in my department's bucket on a weekly basis to show their office's their relevant records.

Is there a way to setup a one-click process that will create all of these reports in an easily e-mailed format?

Thanks,
David

[pbaldy]

I'd start here:

Emailing a different report to each recipient

[dczeman]

Thanks. I guess I'm less interested in the e-mailing of the reports and more interested in just being able to use a one-step (or click) process that will filter out the records by employee and create a separate report for each.

I am familiar with excel and basic access for querying but not so much in writing SQL strings or programming so would need a bit more of a novice approach to this if possible.

[pbaldy]

The same technique can be adapted, using OutputTo or TransferSpreadsheet to create files instead of emailing. The basic bit is to loop a table/query of employees and create a report for each. The first link shows a way to let the report filter itself, there's a link within for the looping method (which has does some other things that can be dropped).