subsorting a listbox

D

Damon Heron

I have a listbox with three fields that's populated by a sql statement that
is sorted ascending by the third field. Is there a way to sub-sort it based
on the second field also?
 
B

Barry Gilbert

Just comma seperate you sort by clause in the SQL statement:
SELECT Field1, Field2, Field3 FROM MyTable Sort By Field3, Field2

HTH,
Barry
 
Top