Trying something different - I'm trying to JOIN the DSUM results to the SELECT query
Again, both the SELECT & the DSUM queries work fine independently - now how do I JOIN
AND is this even a good way to do what I'm trying to do??
Code:
SELECT CallDate, AgentID, EmpName, TeamName, Location
FROM TblACD
WHERE TblACD.CallDate = #10/14/2019# AND TblACD.AgentID ="HF171627"
Group By CallDate, AgentID, EmpName, TeamName, Location
JOIN (SELECT DSum("HandleTime","TblACD", "CallDate = #10/14/2019# AND AgentID ='HF171627'") AS HandleTime, DSum("CallsHandled","TblACD","CallDate = #10/14/2019#
AND AgentID ='HF171627'") AS CallsHandled, DSum("HandleTime","TblACD","CallDate = #10/14/2019# AND AgentID ='HF171627'")
/
DSum("CallsHandled","TblACD","CallDate = #10/14/2019# AND AgentID ='HF171627'") AS AvgHandleTime;)
Still needing help if anyone is out there...
Thank You so much...