Sorting Tables and Queries

[TimC]

Is it possible to have multiple sorts in a table or query? For example, I can get the table or query to alphasort by last name, but there is no order for the first name. When I modify the sort, I get first names,but the last name is out of order. Seebelow. How can I sort by last name then firstname? Thanks.

Current Table/Query:

Smith, Mary
Smith, Abby
Smith, John
Smith, Rosie
Smith, Adam

What I want:

Smith, Abby
Smith, Adam
Smith, John
Smith, Mary
Smith, Rosie

[orange]

Order By LastName,FirstName