Calculating overtime pay

[mallard09]

I'm having trouble creating a query for overtime paid. I am needing the dollar amount paid to workers that worked over 40 hours (just the overtime portion). Does anybody have any suggestions for what I need to do to figure out the formula I need? Thanks

[June7]

IMO, Time and attendance for payroll is one of the more complicated databases one can attempt to build because of labor and tax laws. I wouldn't. I would buy Quickbooks.

Don't know you db structure so can't give specifics. But basically probably need to calculate the total hours per week for each employee and subtract 40. An aggregate query should produce the weekly summary.

[mallard09]

Thanks for the reply. I already have the total hours for the two workers, which is 55 and 50 for the particular week. The wage rates are $8 and $10. I need to make an additional column for the overtime pay. I have to do it on access so I don't have many options. If you need anymore additional info, let me know. Thanks for the help

[June7]

If you have the totals and you know you need another field, what is the issue? Join that query to the table that has the employee wage rates and do the extended calcs in other columns. Then use the query as source for a report and make it look pretty.