sort in one column then in another at the same time

[Guest]

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?

 

[Douglas J Steele]

Use a query, with an appropriate ORDER BY clause in it.

 

[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?

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

 

[Michael J. Strickland]

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?

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

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


--

 

[Guest]

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".