Order By Count

[WickidWe]

I have the following Query

SELECT Count(ra.ReliefCode) AS [Count], ra.ReliefCode
FROM tblRelief_Allot AS ra
GROUP BY ra.ReliefCode, ra.ReliefCode
Order By [Count];

The order By Count Does not work as it doesnt know what "Count" is.
How Can I order By the count?

[pbaldy]

Try

ORDER BY Count(ra.ReliefCode)

[ssanfu]

FYI -
Having an object (field) name the same as a function ("Count") is not really a good idea.

Maybe use "CountOfCode" or "CountOfRelief"