|
dougancil
Posting Yak Master
USA
217 Posts |
 Posted - 11/11/2010 : 10:53:26
|
I have the following query:
SELECT DISTINCT [ScratchPad5].EmployeeNumber, Sum([ScratchPad5].totaltime),
case when ([hours]>40,[hours]-40,0) AS ot, case when ([hours]>40,[hours]-[ot],[hours]) AS RegHours
FROM ScratchPad5
GROUP BY [ScratchPad5].EmployeeNumber
and when I try to parse it, I get an error that there is an incorrect syntax near the comma on line 1. Can someone please assist me?
Thank you
Doug |
|
Incorrect Syntax
