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?
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?
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!!