need to get totals on a querey...

[Carrie]

Is there a way for me to get the total # of calls closed and the total event time for each tech?

Here is the SQL...

SELECT Event.AddUser, Call.IsClosed, Event.EventTime, Event.AddDate
FROM Event INNER JOIN Call ON Event.Call_ID = Call.Call_ID
WHERE (((Event.AddDate)>=[Start Date] And (Event.AddDate)<=[End Date]))
ORDER BY Event.AddUser;

I think it may need a sub querey or something.

For those of you that don't know me...I am a novice when it comes to access but I am slowly learning.

 

[Mark_Elford]

Not sure if this is what you are after but give this a go.

SELECT Count(Call.IsClosed) AS CountOfIsClosed, Sum(Event.EventTime) AS SumOfEventTime, Call.ClosedBy, Call.IsClosed
FROM Event INNER JOIN Call ON Event.call_id = Call.call_id
WHERE (((Event.AddDate)>=[Start Date] And (Event.AddDate)<=[End Date]))
GROUP BY Call.ClosedBy, Call.IsClosed
HAVING (((Call.IsClosed)=True));

Having to guess on some fields in tables, so added Call.ClosedBy

Hope this helps?