[AccessD] Union Query with ORDER BY

You could do two seperate queries and then use them in a union query:

For example if the queries were named "qryUpper5" and "qryLower5" your your union would look like:

SELECT *
FROM qryUpper5
UNION
SELECT *
FROM qryLower5


Scott