query expression

[exphtur]

I have an ASP script that connects to a Microsoft Access database and returns a payroll report. I have been able to get it to display totals of hours worked by hourly rate for each employee, but I want to be able to calculate time-and-a-half for hours worked in excess of 40 hours and double-time for hours worked in exces of 45, do I need to do this by creating an expression within the query ? If so how, please?

Thanks

webtoon

 

[r937]

[tt]select employeename
, sum(hoursworked) as totalhoursworked
, iif(sum(hoursworked) > 40
, iif(sum(hoursworked) <= 45
, sum(hoursworked)-40 , 5 )
, 0 ) as timeandahalfhours
, iif(sum(hoursworked) > 45
, sum(hoursworked)-45
, 0 ) as doubletimehours
from payrolltable
group
by employeename [/tt]

rudy

http://r937.com/