How to calculate weekly overtime?

[watrout]

I'm working on a job-costing database and I want to calculate overtime based on the employee's hourly pay. Basically I need to figure out how many hours (each week) a given worker goes over 40. Then take (1.5 x pay) x overtime hours - or I might just add an overtime wage field on the same form where the base wage is located. Problem is I have no idea how to tell Access calculate hours per week. Also - I don't neccessarily want to save the weekly overtime pay, I want it to be calculated from a query based on a time period the user specifies.

Any help would be greatly appreciated. Thanks

 

[LNBruno]

If you're creating a query, it would go something like this:

SELECT Employee, ((1.5 * HourlyPay) * WorkHours - 40)) AS OTpay 
FROM tablename;

where Employee, HourlyPay, and WorkHours are fields in your table (tablename).

Hope this helps.

< M!ke >

 

[watrout]

I understand how to calculate the overtime pay but I can't figure out how to isolate 1 week blocks of time from which the overtime hours will be calculated.

Example: During a 1 month period Joe Smith works as follows -- Week 1-60 hours -- Week 2-30 hours -- Week 3-30 hours -- Week 4-40 hours.

If I were to create a month summary and just used the total hours for that month I would think Joe Smith had 0 hours of overtime for the month when in actuality he worked 20 hours of overtime. So how do I tell Access to identify week blocks and use those blocks to figure overtime hours worked?