koolwaters
Active Member
- Joined
- May 16, 2007
- Messages
- 403
I have a database which tracks training done by staff and I need to generate monthly reports based on training done.
I need to produce a monthly report which details the number of courses in that month, the hours of training and the number of employees trained.
Here is my problem!
Let's say 10 employees attended 10 different courses in January with a duration of 1 hour each. For my report, I need:
No of Sessions 10
No of Hours 100
No of Employees Trained 10
So in essence, even though the employee may have attended a number of courses during the month, that employee needs to be counted only once.
I have tried several queries to no avail and have been manually counting the employees. The problem is that for October, I would have over 200 individual employees attending training and it is a bit tedious having to count them every month.
Is there any way that I can create a query to give me this info?
Any help is greatly appreciated.
Michelle
I need to produce a monthly report which details the number of courses in that month, the hours of training and the number of employees trained.
Here is my problem!
Let's say 10 employees attended 10 different courses in January with a duration of 1 hour each. For my report, I need:
No of Sessions 10
No of Hours 100
No of Employees Trained 10
So in essence, even though the employee may have attended a number of courses during the month, that employee needs to be counted only once.
I have tried several queries to no avail and have been manually counting the employees. The problem is that for October, I would have over 200 individual employees attending training and it is a bit tedious having to count them every month.
Is there any way that I can create a query to give me this info?
Any help is greatly appreciated.
Michelle