Access VBA

Hi Dafydd

Thank you for your question

It is certainly possible to automate the above process by writing a couple of procedures in a module. The first procedure would cycle through each employee in the relevant recordset, and then pass that name to a procedure which would run a query with that employee as the parameter. It would then build a report based on that query.
This would require a good knowledge of Access VBA as covered on our access vba course

Regards

Stephen