Union query but just add the result of each query instead of mixing the records

[Fionfion]

There are around 12 queries in my database, and I intensionally named them in alphabetical order.



I am trying to append the queries results like below:
Query A result
(An empty line)
Query B result
(An empty line)
Query C result
(An empty line)
....

I have tried Union query, but it will mix all the results together when I just want them to append.

Please help... Thanks in advance!!

[CJ_London]

Assuming are talking about say two fields try something like

SELECT fld1, fld2 FROM
(SELECT 1 AS ord, fld1, fld2
FROM query1
UNION SELECT 2 AS ord, null, null
FROM Query1
UNION SELECT 3 AS ord, fld1, fld2
FROM Query2
UNION SELECT 4 AS Ord, null, null
FROM Query1
…
…) AS UC
ORDER BY Ord

although I don't understand why you would want to do this. If for presentation purposes, I would suggest it is not the way to go. Certainly don't understand why you would want to append blank records to a table

[Fionfion]

Assuming are talking about say two fields try something like

SELECT fld1, fld2 FROM
(SELECT 1 AS ord, fld1, fld2
FROM query1
UNION SELECT 2 AS ord, null, null
FROM Query1
UNION SELECT 3 AS ord, fld1, fld2
FROM Query2
UNION SELECT 4 AS Ord, null, null
FROM Query1
…
…) AS UC
ORDER BY Ord

although I don't understand why you would want to do this. If for presentation purposes, I would suggest it is not the way to go. Certainly don't understand why you would want to append blank records to a table

Thank you so much for your help it worked perfectly! And yes it is for presentation purpose