How to sort the field' value after accessing them from MS Access 1

[qb828]

Hi Guys!

I don't know how to sort the field value.

I am accessing the one field values from the Acess database using the ASP and inserting them into the listbox(would like to insert in alpabethically)

Example)
I have address book in Access.
I am populating all the last name into the listbox so I can select one person's last name and pull entire address information from the acess database.

Can you help me to sort the last names after I got them from the database ??
THanks.



QB

 

[andybeh]

Hi,

Try setting up your sql select string like this:

strSQL = "Select * From tbladdressbook ORDER BY fldSurname DESC;"

Substitute tbladdressbook for your table name and fldSurname with the name of the field you want to sort by.

If you want to sort from A-Z remove 'DESC'.

Cheers

ab

 

[qb828]

Thanks millions, ab.

Totally forgot about the sql stuffs.

Thanks.

QB