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

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 ???.

VB Code:

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

VB Code:

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

Thanks aktell GER/NZ

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 :)

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

VB Code:

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

VB Code:

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