recordset order problem

[grohl]

I use the following script to get data from an MS Access database:

Set rs = Server.CreateObject("ADODB.Recordset&quot
sSQL = "SELECT DISTINCT name, SUM(hits) FROM tablename GROUP BY name"
rs.open sSQL, cn, 3, 3

What I would like to do is order the results by SUM(hits).
How can I do that?

 

[link9]

sSQL = "SELECT DISTINCT name, SUM(hits) AS sumOfHits FROM tablename GROUP BY name ORDER BY sumOfHits"