Trying to display the percent sign at the end of a percentage field

[gmccray]

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!

[JoeM]

You can use the FORMAT function. See: http://www.techonthenet.com/access/f...ric/format.php

Note: If you use this FORMAT function with the percent option, you won't need to multiple your results by 100 first.
As they show in the example,

Format (0.981, "Percent")
Result: '98.10%'

[June7]

Is this query the RecordSource for a report? Set Format property of textbox.

Or

Set Format property on field in query.

Or

Use Format() function - however, this results in a text string, not a number value.

Or

Concatenate value with % character - again, results in a text string, not a number value.

[gmccray]

Thank you!