Full Name ordered by LastName

[tizwaz]

I have 2 fields - FirstName and LastName which I have combined to make FullName. However although I would like it to display with the First Name first and then the Last Name I would like to order it by Last Name first then First Name. does anyone know how I would go about this?

 

[PHV]

Something like this ?
SELECT FirstName & ', ' & LastName AS FullName
FROM yourTable
ORDER BY LastName, FirstName

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DaOtH]

Tizwaz,

Just make it something like the following

SELECT Firstname + ' ' + Lastname AS FullName
FROM tblNames
ORDER BY Lastname


(Create a query, go to SQL view and cut and paste above statement, don't forget top change the field/table names)

"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963