Sorting

[k209310]

i have a list bo that displays unique information taken from a database.

How is it possible to display the information in alphabetical or Numerical ordeer

 

[Tay]

You could use ORDER BY in the Row Source of your list box if you have a SQL statement.
EG. ORDER BY qryWhatever.CustomerID
Where your data comes from a query (or table - whatever you're using) and CustomerID is the field you are displaying in the listbox.
HTH

 

[paulmcdonnell]

use a Query mate!

simpler....

Use the queries listing to create a new query.

select the whole table (*) and click on a column you want to sort by in the table window.

The click the sort dropdown in the QEB(Qery expression builder) and sore records by the column you choose.

HTH
Paul