Changing the sort order of a union query

[_JSincliar]

I have a which combines the results of a few other queries. When I run it, Access automatically sorts it alphabetically on the first column. Instead, I would like it to preserve the order in which the input queries are written. ie,

SELECT  Content FROM qryFormatT1
UNION
SELECT  Content FROM qryFormatTT;

qryFormatT1 returns,
a
d
h

qryFormatTT returns.
c
r
e

Result of the union: (sorted alphabetically):
a
c
d
e
h
r

I want: (one query sitting on top of the other, not sorted):
a
d
h
c
r
e

Any help is appreciated

 

[pbaldy]

Try

SELECT Content, 0 AS SortField FROM qryFormatT1
UNION
SELECT Content, 1 AS SortField FROM qryFormatTT
ORDER BY SortField