Sum in a group

[peterpater]

Hi:
I have a table with the following fields:
-EmpID
-Date
-Event (Project)
-TimeSpentInEvent (in sec)


I am trying to write a query which will give me a sum of TimeSpentInEvent for an event for a day per Employee. (For eg: John may be in a Project from 11am-12pm and 3pm-4pm on Aug 3rd). So the query result would give:
EmpID - John
Date - Aug 3, 2006
TotalTimeSpent - 2hrs (in seconds ofcrs)

I have tried using SUM, but I get the error "Data Type Mismatch in Criteria Expression". I am not too sure if DSum will have, as I am having errors with the syntax.

Any help is appreciated.

 

[PHV]

SELECT EmpID, [Date], Sum(TimeSpentInEvent) AS TotalTimeSpent
FROM yourTable
WHERE [Date] = #2006-08-03# AND Event = 'Project'
GROUP BY EmpID, [Date]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[peterpater]

Thanks, it helped!