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.
