summary by weeks

[Guest]

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

 

[Jeff Boyce]

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

 

[Guest]

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!

 

[Jeff Boyce]

Ibo

Then I would focus on creating a query (or chain of queries) that allows you
to:

calculate weekly totals per Employee
exclude weekly totals less than 40 hours

Please post the SQL statement of the queries you mention, and described how
they "didn't work" -- does that mean they generated incorrect results, or
they gave an error message when run?

--
Good luck

Jeff Boyce
<Access MVP>

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!

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

--
Good luck

Jeff Boyce
<Access MVP>

do
the numbers
and