Results 1 to 3 of 3
  1. #1
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108

    need to show total hours worked for each employee after a specified date


    Hello,I need to calculate the amount of hours an employee worked after the date specified in the Date_LEI field. so if Bob has a total of 1000 hours, but i only want the 100 hours after his Date_LEI how would i go about doing that?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521

    make Q1 your base query by getting your recs after the DATE_LEI, so it would be:
    select * from table where [WorkDate] > table.Date_Lei

    Q2, uses query Q1 to sum the Hrs for the days, or week.



  3. #3
    willmafingerdo is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    108
    Quote Originally Posted by ranman256 View Post

    make Q1 your base query by getting your recs after the DATE_LEI, so it would be:
    select * from table where [WorkDate] > table.Date_Lei

    Q2, uses query Q1 to sum the Hrs for the days, or week.



    Thanks runman!! i got it running, now ill test to make sure i got it set up right!!

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

Similar Threads

  1. Summarize hours worked between M-F
    By jbeets in forum Queries
    Replies: 8
    Last Post: 03-20-2020, 10:08 AM
  2. Consolidating Hours Worked in Day Query
    By blimbert in forum Queries
    Replies: 9
    Last Post: 01-15-2020, 07:54 PM
  3. Sum of worked hours
    By infratunes in forum Access
    Replies: 9
    Last Post: 10-24-2018, 12:29 AM
  4. Replies: 2
    Last Post: 11-09-2015, 01:24 PM
  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