Sorting Data in an Access Query

[Guest]

How do I sort a set of data within a query that has already been sorted
alphabetically? For example, I have sorted the entire query alphabetically.
Now I want to apply another sort to different sections of the query. Please
help - I am at a loss.

 

[Douglas J. Steele]

You can sort by mutliple fields in a query:

ORDER BY Field1 DESC, Field2, Field3 DESC

To do this via the graphical query builder, you just make sure that the
fields on which you want to sort are in the correct sequence (hint: you can
add the fields a second time and uncheck the checkbox in the Show row), and
pick the appropriate option in the Sort row under the field names.