Results 1 to 3 of 3
  1. #1
    MFS is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235

    Query To Show Average Hours Worked In Each Department

    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

  2. #2
    bigot is offline Advanced...ish
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    37
    Create a new query, and click the "Totals" option (in the Ribbon under the "Design" tab).
    Drag your old query in. Select "Department" (Total: Group By), "Shift" (Total: Group By), and "Total Overtime Worked" (Total: Average).

    Is this what you're looking for or am I missing some information?

  3. #3
    MFS is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2009
    Location
    Ohio
    Posts
    235
    Thank You bigot, That helped a lot.

    Speck

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-23-2014, 11:51 AM
  2. Replies: 4
    Last Post: 01-17-2014, 10:53 PM
  3. Replies: 8
    Last Post: 03-01-2013, 11:55 AM
  4. calculate rate * hours worked
    By hamish mather in forum Queries
    Replies: 1
    Last Post: 12-22-2011, 06:14 AM
  5. Sum hours worked, grouped by dep't
    By goodfood in forum Queries
    Replies: 3
    Last Post: 05-05-2011, 06:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums