sort on multiple fields in an Access query

[Guest]

I created a query in Access using Query Design View. I want the query to sort
the results first by one field, and after that, sort by another field. I see
how you can tell it to sort this field acending or decending, but I don't see
a way to say "Sort first on this one, second on that one." The online help
didn't help. Thanks.

 

[Rick B]

It just goes in order. Put the primary sort to the left of the secondary
sort.

Rick B

 

[Guest]

Unfortunately, I cannot include a picture on this post...it would make this
easier. However, I will do my best to explain below.

Let's say you have a query that has fields F1, F2 and F3. You want the
FIELDS to be displayed in that order from left to right when the query is
run, but you want the DATA to be ordered like the following: F1, F3, F2.

I hope that's what your asking for!

To accomplish this:
1. Drop the fields into the QBE (query by example) grid in the lower
part of the screen: F1, F2, F3, and F2 again!
2. Set the sort property for F1 and F3.
3. Remember that second F2 that you added in step 1? Well, turn of it's
"Show" property and set property, too.

Now run the query.