Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 How to....

Author  Topic 

D0LeM1Te
Starting Member

3 Posts

Posted - 2004-10-29 : 14:42:01
Can any1 help me with how to return a query in Alphabetical Order.. Ex. have the results ordered by last name...

thank you

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-10-29 : 14:45:59
if you are using the "Design View" grid for queries, then you just choose a column to order by, and in the row that says "Sort" choose Ascending or Descending.

Easy as that.

- Jeff
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-10-29 : 14:47:20
Sort the last name column Ascending



Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -