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!

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

Alphabetical order search

Status
Not open for further replies.
chassid

chassid

MIS
Aug 27, 2000
58
US
To all,

I am making a search on a database through a query. After the results are displayed I would like them to always be displayed in alphabetical order by the last name. Does anyone know how to do this? I would greatly appreciate it!

Daniel
 
Sort by date Sort by votes
In your query you should use Order By last_name and your recorset will be sorted alphabetically; by default -- ascending (a,b,c,d,etc).
If you put desc after the last_name it will be sorted descending(z,y,x,etc).
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gesrod
  • Locked
  • Question
Multiple search criteria
Replies
2
Views
137
gesrod
gesrod
leifoet
  • Locked
  • Question
Selection query : problem with 'ORDER BY'
Replies
4
Views
149
leifoet
leifoet
Floodster39
  • Locked
  • Question
Highlght search term but ignore HTML markup
Replies
1
Views
89
guitarzan
guitarzan
mayamanako
  • Locked
  • Question
Highlight, popup Search box 1
Replies
2
Views
89
mayamanako
mayamanako
jasonhuibers
  • Locked
  • Question
Paypal - Submit order and listner
Replies
3
Views
73
jasonhuibers
jasonhuibers

Part and Inventory Search

Sponsor

Back
Top