SQL Statement Sorting LastName by A, B, C ...

[aktell]

Hi there,

How would I be able to set the SQL Statements so that I have the LastName by A, B, C ... SORTED and NOT by the ID as it is now ???.

Public Function FillList()
'---
    str_SQL = "SELECT ID, LastName+', '+FirstName FROM tblAddr"
 
End Function

Public Function GetAddressDetails()
 
    str_SQL = "SELECT * FROM tblAddr Where ID =" & lngAddrID
 
End Function

Thanks aktell GER/NZ

[wildcat_2000]

str_SQL = "SELECT ID FROM tblAddr ORDER BY LastName"

don't get though if LastName and FirstName are two different fields, the LastName+', '+FirstName remains a mistery to me

[si_the_geek]

This will order by LastName, then Firstname when the LastNames match

str_SQL = "SELECT ID, LastName+', '+FirstName FROM tblAddr ORDER BY LastName, FirstName"

str_SQL = "SELECT * FROM tblAddr Where ID =" & lngAddrID + " ORDER BY LastName, FirstName"