Help Creating a Query to Extract 2 Results from same table

[RunTime91]

Greetings ~



I am trying to create a query that will provide two results from the same table

This essectially takes the previous query I was working on here and adds another field and provides another result from the same data

Below is the query which at the moment produces a Dupliate Output Alias Error on the HandleTime field

SELECT TblACD.CallDate, TblACD.AgentID, TblACD.EmpName, TblACD.TeamName, Sum(TblACD.HandleTime) AS HandleTime, Sum(TblACD.CallsHandled) AS CallsHandled, Format((HandleTime/CallsHandled),"0") AS AvgHandleTime, 
Sum(TblACD_1.HandleTime) AS HandleTime, Sum(TblACD_1.CallsHandled) AS CallsHandled, Format(([TblACD_1].[HandleTime]/[TblACD_1].[CallsHandled]),"0") AS AvgHandleTime2
FROM TblACD, TblACD AS TblACD_1
WHERE (((TblACD.CallDate)=#10/14/2019#) AND ((TblACD.AgentID)="HF171627") AND ((TblACD_1.CallDate)=#10/14/2019#-3) AND ((TblACD_1.AgentID)="HF171627"))
GROUP BY TblACD.CallDate, TblACD.AgentID, TblACD.EmpName, TblACD.TeamName, TblACD.Location, TblACD_1.CallDate, TblACD_1.AgentID;

I've tried to alias the HandleTime Field but then, of course I get a plethora of other errors: Circular/Not part of Aggregate Function/ et.al

I'm sure (ok I hope) this one will be easier than the last one

Sorry 'bout that btw - the solution was right in front of my face and I just couldn't see it.

Thanks as always for any help

[ranman256]

make Q1 to get your data,
make Q2 that uses Q1 to get the 2nd datum.
combine them in a union query:

select * from Q1
union select * from Q2

[RunTime91]

RanMan - Thank You!!!

This Worked!

(SELECT TblACD.CallDate, TblACD.AgentID, TblACD.EmpName, TblACD.TeamName, TblACD.Location, Sum(TblACD.HandleTime) AS HandleTime, Sum(TblACD.CallsHandled) AS CallsHandled, Format(([HandleTime]/[CallsHandled]),"0") AS AHT
FROM TblACD
WHERE (((TblACD.CallDate)=#10/14/2019#) AND ((TblACD.AgentID)="HF171627"))
GROUP BY TblACD.CallDate, TblACD.AgentID, TblACD.EmpName, TblACD.TeamName, TblACD.Location)


UNION


(SELECT TblACD.CallDate, TblACD.AgentID, TblACD.TeamName, TblACD.TeamName, TblACD.Location, Sum(TblACD.HandleTime) AS HandleTime, Sum(TblACD.CallsHandled) AS CallsHandled, Format(([HandleTime]/[CallsHandled]),"0") AS AHT
FROM TblACD
WHERE (((TblACD.CallDate)=#10/11/2019#) AND ((TblACD.AgentID)="HF171627"))
GROUP BY TblACD.CallDate, TblACD.AgentID, TblACD.EmpName, TblACD.TeamName, TblACD.Location)

Thank You again, Ranman...