SQL

  • Thread starter Thread starter Stewart
  • Start date Start date
S

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.
 
Never Mind, I'd MisSpelled something and had it right all
along, Sorry.
 
Select State, City, NameField
From YourTable
Order By State, City;
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Strange value added to table 3
Trouble changing the Row Source for a Combo Box Access 2007 - SQL 2000 1
Combo Box to populate variable output range 5
Filter based on value in combo box 1
User Login Filter 1
Combo Box not refreshing after changing Row Source in code 0
Change or omit criteria for combo based on text box 0
Combo box - showing active items only 6

Back
Top