blueboy2001
Registered User.
- Local time
- Today, 21:56
- Joined
- Apr 22, 2002
- Messages
- 26
I am producing a fairly complex (to me) report to show staff performance. Each job is categorised as one of three categories - major, minor or other; and job duration is measured in weeks as the difference between 2 dates. I have all the data in a query based on multiple tables. Each row has the time taken in weeks calculated using DateDiff.
The query shows job number, staff member, job category, job result, and time taken.
Up to now I have a report that groups by staff name, then each job type and I have the list of jobs with a summary count for each type. Its the next bit I'm struggling with.
We have performance targets that differ between job types, so I need to know how many major jobs were completed in 13 weeks or less, and how many ran over 13 weeks. I would like a percentage for each member of staff, as well as an overall percentage for the whole office. For minors and others the target is 8 weeks.
What is the easiest way to go about this? I did sort of get something working for individual staff members using lots of DCount's but it took an age to run and produce the report. I'm thinking it may be a job for VBA but I'm not sure where to start with that.
The query shows job number, staff member, job category, job result, and time taken.
Up to now I have a report that groups by staff name, then each job type and I have the list of jobs with a summary count for each type. Its the next bit I'm struggling with.
We have performance targets that differ between job types, so I need to know how many major jobs were completed in 13 weeks or less, and how many ran over 13 weeks. I would like a percentage for each member of staff, as well as an overall percentage for the whole office. For minors and others the target is 8 weeks.
What is the easiest way to go about this? I did sort of get something working for individual staff members using lots of DCount's but it took an age to run and produce the report. I'm thinking it may be a job for VBA but I'm not sure where to start with that.
