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

 

[Bob2]

You will probably have to create one more recordset that get's the information once more (without the SUM function) and then you pass the numbers into a asp/vbscript function that do the calculation for you.


Regards


M

 

[foxbox]

Something like this:

SELECT employeeid, ( SUM(hours) - 45 ) * @HOURLYRATE
FROM payroll
GROUP BY employeeid
HAVING SUM(hours) > 45

br
Gerard