I have to wonder if you know how to use sql in vba will the answer given make any difference? You'd have to know that when not specified in vba the default sort is ascending, which makes me think that you might also need to know that the query design provides a Sort: row.
I don't see any issue with doing it in vba, especially if you have several sorts you want to provide. Let's say
- sort by A ascending
- sort by A descending
- sort by B ascending
- sort by B descending
- sort by A ascending and B descending
- sort by A descending and B ascending
... and so on. So what, design 8, 10, 12... queries for one purpose or learn some vba?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.