Here is what I am trying to do,
My database tracks employee overtime, weekly.
In the database I have numerous departments, each department has a 1st, 2nd and 3rd shift. I would like to be able to have a query show the average amount of overtime of each department by shift.
Example:
Dept. A 234.72 hours
Dept. B 240.68hours
Dept. C 248.02hours
Dept. D 268.75 hours
My query has the following columns . . .
Employee Name.
Employee Clock Number.
Pay Period End Date.
Total Overtime Worked.
Department.
Shift.
Hope someone can help,
Thank You,
Speck