Pass Sort Order from One Query to another

[cariengon]

I have 3 queries that need to be sorted in the same order for purposes of a final report. The sort order on the first query that needs to be the "Master" is based on criteria that is only in that query. I don't want to have to add the items that make up the field that the sort order is based on in the other queries mainly because of the time involved for the queries to run.

I was hoping that there was a magical way to use this "master" query's sort order and pass it to the other 2 queries.

Anyone know of any shortcuts?

 

[BNPMike]

You have a slight problem here in that the report will do its own sorting.

 

[cariengon]

This has nothing to do with the report. I extract three queries into an Excel spreadsheet. I want all 3 queries to sort based on the sort of only 1 of the queries.

I couldn't figure out how to do it in Access without slowing down the query process, so I just created a work around using a new column called Sort Order in all three tabs and did a vlookup to make it work...

Thanks anyway!