SQL

[Stewart]

Just need some quick help with an SQL statement I'm using
as a rowsource for a combo box. I want it to sort
primarly by State, and secondarly by City.

ex) California | LA | Dude
California | San Fransisco | Dude2
New York | New York | OtherGuy

Also, I'm writing the RowSource SQL Statement in VBA.

 

[Stewart]

Never Mind, I'd MisSpelled something and had it right all
along, Sorry.

 

[Lynn Trapp]

Select State, City, NameField
From YourTable
Order By State, City;