Sort by multiple fields

[Guest]

Hi

I want to sort a Query by two fields
For example: First by "Age" and second alphabetically by name

How do I do this? I can only sort one at a time

I am very new to Access - is there a simple way to do this?

 

[Ken Snell]

You can sort more than one field at a time. Open the query in design view,
and under each field that you've selected for the query is a cell named
"Sort". Simply choose which order you want for each field. Sort precedence
is that the field to the furthest left will be the first sort, the next
field the next sort, etc.