I am trying to get a dropdown list to show the items in Alpha order but can not get the SQL statement that works. Here is my current command line:
SELECT IIf([tblCustomerMain].[CustFirstName] Is Null,[tblCustomerMain].[CustLastName],[tblCustomerMain].[CustLastName]+", "+[tblCustomerMain].[CustFirstName]) AS CustomerName, tblCustomerMain.CID
I would like the Alias "CustomerName" to be listed by the CustLastName Alpha order. I greatly appreciate any help.