Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting A Table (beginner)

Status
Not open for further replies.

LongFeiFengWu

Technical User
Nov 9, 2001
98
US
I have a table with Date, FirstName, LastName, Type, Start, Stop, and Total fields. I am already using the ORDER BY Date to sort by date, but I also need to sort by LastName at the same time. Is this possible?
 
Sorry, hit Enter too soon :)

ORDER BY Date, LastName

This will order by Date FIRST then LastName. You can add as many fields to the ORDER BY as you want.

Hope this helps.

-Greg
 
Thanks So Very Much!! That was the fastest reply I have ever received!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top