Unanswered: Changing the Query Sort order using VBA
I have got a query, that is fairly complex. It works nicely, but the users want to chose which field to sort on prior to displaying it (about 15 different possibilities). Because of the complexity of it and because it is the underlying query to several reports, I would like to be able to change the sort order to this query prior to displaying it to the user, using VBA. Is it possible to do this, or is there any other options that I haven't thought of? The only other option that I can think of is to just make multiple queries (that are identical, outside of the sort order) and display the one that corresponds to the sort order they want.