I want to sort by 'PopRank' so that 1, 2, 3 come before 1, 10, 11.
Pop Rank is formated as a number.
Not sure of the best way to handle this issue with a number sort.Code:StateList.RowSource = "SELECT [MapID], [State], [Population], [PopRank] FROM StateMapT ORDER BY PopRank;"
Thanks
Jim O