Query Output with text?

[dan]

Hi,
Using access, I am using UNION ALL to output two queries. Is there a
way to get a blank line or some text to be output in the middle of the
two queries like this:

Query1
UNION ALL
(blank line or Title)
QUERY2

Thanks!

 

[Guest]

Create a third select statement, something like this:

Select Field1, Field2, Field3 FROM table1
UNION
SELECT null as Field1, null AS Field2, null As Field3 FROM Table1
UNION
SELECT Field1, Field2, Field3 FROM Table2

Barry