Auto run same report for all available criteria options

[mitchy1111]

Hi,

I have a report (EmployeeSchedule) which shows an employees whereabouts on certain days. The criteria for the report is selected from a form (employeeName and Date Range) and this populates the query that the report is based on.

Users can run the report no problem for an individual employee but I wondered if there was a way of generating the same report over and over for all employees in one go using a command button. i.e. If there is 10 employees in the employee list, re-run the report 10 times with same date range but each time change the employee.

Thanks

 

[pbaldy]

These contain the shell of what you want to do:

http://www.granite.ab.ca/access/email/recordsetloop.htm

http://www.baldyweb.com/wherecondition.htm

You would use the loop to get your employees, and include the current value from the recordset in the wherecondition argument of OpenReport. You can also explore grouping the report in such a way that it breaks on employee (putting each on a separate page). That would let you just print the report and get everybody.