40 hour ratio formula

[sdurocher]

I need a formula on my Access query to sum hours; by person, by pay period, by project and If those hours are greater then 40 then calculate a percetange of those project hours to the sumed hour and mulitple them by 40.

The hours for each person per pay period can not be greater that 40 for capiltaztion purposes. I need to get what the true hours are and change the hour (if over 40) to the a ratio per project for a 40 hour week.

SELECT Union_Dates.PayPeriod, Union_Dates.Approve, Union_Dates.Name, Union_Dates.ProjectName, Union_Dates.ProjectDescription, Union_Dates.dbo_TimeSheetTable.Date1, Format([Months.Date1],'mmm') AS [Month]
FROM Union_Dates
GROUP BY Union_Dates.PayPeriod, Union_Dates.Approve, Union_Dates.Name, Union_Dates.ProjectName, Union_Dates.ProjectDescription, Union_Dates.Billable, Union_Dates.dbo_TimeSheetTable.Date1, Format([Months.Date1],'mmm')
HAVING (((Union_Dates.Approve)="A") AND ((Union_Dates.Billable)="Y"));