sorting data base rows.

[jerry chapman]

Is there a way to sort on multiple columns without arranging the columns in
the desired sort order?

 

[John Nurick]

If you're working in the query design grid, add second copies of the
columns to the grid in the desired sort order, set them to sort as
needed, and then uncheck the "Show" box on each of them.

Take a look at the SQL view of the query before and after doing that and
you'll see how its done.