SQL Statement, Ascending

This is the sql statement im using how do i get it to do ascending

tempSQL = "SELECT City FROM Cities WHERE StateID='" & strStateID & "';"
thaburnerAsked:
Who is Participating?
 
manthaneinCommented:
It think its'
tempSQL = "SELECT City FROM Cities WHERE StateID='" & strStateID & " ORDER BY [field] ASC';"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.