ORDER BY

[Guest]

How do I use the SELECT statement to display records in a listbox first by
Field1 and then by Field2? The normal statements I've used so far are like:
"SELECT field1,field2,field2 from Table1 ORDER BY FIELD1". I want it to ORDER
BY FIELD1 and THEN BY FIELD2. How I do that? Thanks.
ck

 

[Allen Browne]

MyListbox.RowSource = "SELECT Field1, Field2 FROM Table1 ORDER BY Field1,
Field2;"