SELECT OperatorID, 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]))
GROUP BY OperatorId;
Hi, I am trying to display the percent "%" sign in the column that displays the percentage amount. I've tried everything I can think of, can someone help me? The code is above. Thanks!