summary by weeks

I

Ibo

My database has two tables to analyze hours worked for my agency. Can do the
report to summarize hours worked on a weekly basis, but I'd like to print
only those sums that >40 hours. Help!?
Table 1--Pay ID, Employee
Table 2--Pay ID, DateWorked, TimeIn, TimeOut
My query includes a (DatePart "ww") expression identify the week numbers and
an expression for a daily sum of HoursWorked. I'm stuck here.

Thanks! I hope this is in the right place
 
J

Jeff Boyce

If you have a query that generates (sum) hours worked, couldn't you set a
criterion of >40 for that?
 
I

Ibo

Jeff,
Thanks! for your reply.
Unfortunately, I have not been able to cause my query to sum the hours for a
weekly sum, by employee, other than in the report generator.
When I tried to create another query based on the first one didn't work.
FYI, I used this formula to derive the daily hours worked: [HOURS WORKED:
Round((DateDiff("n",[TIMEIN],[TIMEOUT])/60),2)]. Then, in Report Generator I
used [DatePart("ww", (DATEWORKED)] and [=SUM([HOURS WORKED])] to report the
total hours worked per week. At this point, either in a query or report
generator I'd like to be able to filter the records for ">40", but the query
will not provide the column.

I hope this sheds light on my dilemma and ability to help. Thanks!
 
Top