Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Location
    Tampa, Florida, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lag Time (Office 2003)

    I have job logs for my employees which include the date, time in, time out and jobs. I have been asked to give a percentage of time each month spent on individual jobs. Luckily, we only work on three different types of jobs. I have used the Microsoft tutorials, but am not having any luck. Any help would be appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lag Time (Office 2003)

    Do you want the percentage per employee, or aggregated over all employees?

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lag Time (Office 2003)

    Try the attached database. The qryEmployeeJobPercentage query returns a percentage per job for each employee per month, and the query qryJobPercentage returns a perventage per job per month.

  4. #4
    New Lounger
    Join Date
    Oct 2002
    Location
    Tampa, Florida, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lag Time (Office 2003)

    This really helps, thanks so much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •