subsorting a listbox

  • Thread starter Thread starter Damon Heron
  • Start date Start date
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?
 
Just comma seperate you sort by clause in the SQL statement:
SELECT Field1, Field2, Field3 FROM MyTable Sort By Field3, Field2

HTH,
Barry
 
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

List Box won't refresh 2
Populate Listbox 3
ADDING values from one listbox to another on same form 1
Subsorting in Query 1
depending listboxes 7
Listbox Itemdata editable at runtime? 9
Update listbox. 6
how to double click a list box item to add to subform 6

Back
Top