SQL to Access - Can I ORDER BY a SUM column 1

[elvenmaiden]

This is what I have, but it doesn't seem to recognize the AcceptanceRate as a valid sort field.

SELECT qryStats.Name, qryStats.Subject, qryStats.Questions, qryStats.Solutions, AVG(qryStats.AcceptRate)as AcceptanceRate FROM qryStats WHERE qryStats.UserEmail = '&quot; + mstrUser + &quot;' AND qryStats.OrigDate >= # &quot; & DTPBegin.Value & &quot; # AND qryStats.OrigDate <= # &quot; & DTPEnd.Value & &quot; # GROUP BY qryStats.Name, qryStats.Subject, qryStats.Questions, qryStats.Solutions ORDER BY AcceptanceRate

 

[bjd4jc]

Use ORDER BY AVG(qryStats.AcceptRate) instead of ORDER BY AcceptanceRate.