sort in one column then in another at the same time

A

all_praise

How can I sort info in one column then in another without changing the sort I
first made? For example: I want to sort a "last names" column and get all
the Smith's in order then sort a "first names" column so I can get all the
Smith's in order by last AND first name. How do I do this?
 
F

fredg

How can I sort info in one column then in another without changing the sort I
first made? For example: I want to sort a "last names" column and get all
the Smith's in order then sort a "first names" column so I can get all the
Smith's in order by last AND first name. How do I do this?
Click to expand...

Access sorts fields in left to right order, so:
Order By TableName.LastName, TableName.FirstName
 
M

Michael J. Strickland

all_praise said:
How can I sort info in one column then in another without changing the
sort I > first made? For example: I want to sort a "last names" column
and get all
the Smith's in order then sort a "first names" column so I can get all the
Smith's in order by last AND first name. How do I do this?
Click to expand...


Move the lastname column to the left of the firstname column.

Then select both columns, right click in the columns, select Sort Ascending.


--
 
A

all_praise

Here's another way: At the top of the screen, click on "Records", then
"filter", then on "advance filter/sort". A box will pop up that will allow
you to choose what fields you want sorted, in what order, and if you want
ascending or decending. After you choose the fields and orders, click on
"Filter" at the top of the filter pop up window, then "Apply filter/sort".
 
Top