So it can be done!
Below is the query I built in the Access Grid - it works perfectly!
Code:
SELECT TblSOPTmp.EmpName, TblSOPTmp.TeamName, Format(Sum([TblSOPTmp].[HandleTime])/Sum([TblSOPTmp].[CallsHandled]),'0') AS [AHT-YD],
FORMAT(Sum([TblSOPTmp_1].[HandleTime])/Sum([TblSOPTmp_1].[CallsHandled]),'0') AS [AHT-LW],
FORMAT(Sum([TblSOPTmp].[CallWorkTime])/Sum([TblSOPTmp].[CallsHandled]),'0') AS [ACW-YD],
FORMAT(Sum([TblSOPTmp_1].[CallWorkTime])/Sum([TblSOPTmp_1].[CallsHandled]),'0') AS [ACW-LW],
FORMAT(Sum([TblSOPTmp].[SchCompliance])/Count(1),"Percent") AS [SC-YD],
FORMAT(Sum([TblSOPTmp_1].[SchCompliance])/Count(1),"Percent") AS [SC-LW],
FORMAT(Sum([TblSOPTmp_1].[QualityScore])/Count(1),"Percent") AS [QA-LM]
FROM TblSOPTmp, TblSOPTmp AS TblSOPTmp_1
WHERE (((TblSOPTmp.CallDate)=#12/10/2019#) AND ((TblSOPTmp.EmpName)='Anna Joseph') AND ((TblSOPTmp.TeamName)='TC_MillerR')
AND ((TblSOPTmp_1.Calldate) Between #12/2/2019# And #12/8/2019#) AND ((TblSOPTmp_1.TeamName)='TC_MillerR')
AND ((TblSOPTmp_1.EmpName)='Anna Joseph') AND ((TblSOPTmp_1.SchCompliance)>0))
GROUP BY TblSOPTmp.EmpName, TblSOPTmp.TeamName;
Below is the same query modified to work in Access VBE - But of course, it doesn't work - It doesn't throw an error but I get nothing as a result...
Code:
.List23.RowSource = "SELECT TblSOPTmp.EmpName, TblSOPTmp.TeamName, " & _
"FORMAT(Sum([TblSOPTmp].[HandleTime])/Sum([TblSOPTmp].[CallsHandled]),'###0') AS [AHT-YD], " & _
"FORMAT(Sum([TblSOPTmp_1].[HandleTime])/Sum([TblSOPTmp_1].[CallsHandled]),'###0') AS [AHT-LW], " & _
"FORMAT(Sum([TblSOPTmp].[CallWorkTime])/Sum([TblSOPTmp].[CallsHandled]),'###0') AS [ACW-YD], " & _
"FORMAT(Sum([TblSOPTmp_1].[CallWorkTime])/Sum([TblSOPTmp_1].[CallsHandled]),'###0') AS [ACW-LW], " & _
"FORMAT(Sum([TblSOPTmp].[SchCompliance])/Count(1),'Percent') AS [SC-YD], " & _
"FORMAT(Sum([TblSOPTmp_1].[SchCompliance])/Count(1),''Percent') AS [SC-LW], " & _
"FORMAT(Sum([TblSOPTmp_1].[QualityScore])/Count(1),'Percent') AS [QA-LM] " & _
"FROM TblSOPTmp, TblSOPTmp AS TblSOPTmp_1 " & _
"WHERE (((TblSOPTmp.CallDate)= #12/10/2019#) AND ((TblSOPTmp.EmpName)='Anna Joseph') " & _
"AND ((TblSOPTmp.TeamName)='TC_MillerR') AND ((TblSOPTmp_1.Calldate) Between #12/2/2019# AND #12/8/2019#) " & _
"AND ((TblSOPTmp_1.TeamName)='TC_MillerR') AND ((TblSOPTmp_1.EmpName)='Anna Joseph') AND ((TblSOPTmp_1.SchCompliance)>0)) " & _
"GROUP BY TblSOPTmp.EmpName, TblSOPTmp.TeamName;"
I'm sure I'm just missing some of the mods - but I can't see which one(s)
Help?