Trying to display OperatorId and corresponding name

[gmccray]

SELECT Sum(AppsChecked) AS TotAppsChecked, Sum((AppsChecked)-(AppErrors)) AS TotAppsCorrect, Round((TotAppsCorrect)/(TotAppsChecked)*100,2) AS PctCorrect,


Sum(AppErrors) AS TotAppErrors, Round((TotAppErrors)/(TotAppsChecked)*100,2) AS PctErrors
FROM Stats
WHERE (((Stats.OperatorId)=[Enter OperatorID]) AND ((Stats.Date) Between [Enter Start Date] And [Enter End Date]));


Hi,
I am trying to display the operator ID and the corresponding name with the other data per the above code. Whenever I try I get an aggregation error. I have attached a excel file with two tabs which contains the tables that I am working with. Please help! Thankls!....GOnLineTestBook (2).zip

[ranman256]

do you have [OperatorId] in the SELECT statement?
I see it in the WHERE, but not the SELECT. (groupBy)

[gmccray]

I tried to put it in there and kept getting a aggregation error.

[gmccray]

Thanks RanMan256, I got the ID, now all I have to do is find a way to bring the name too! Any suggestions?