Here is how to order by ASC or DESC in sql. Use ASC for ascending and DESC for Descending.

Set objGetSort1ENTCensus = cnnConn.Execute("SELECT * FROM qxSQLCensusBasicView ORDER BY occupancy DESC")