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

[willmafingerdo]

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?

[ranman256]

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.

[willmafingerdo]

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