Union Query with seperate column?

[ChuiceBox]

Hi,

I have a union query which successfully returns the totals from other queries but I can't make it return the totals in separate headings. For example currently it returns like this:

Heading:
Total1
Total2
Total3

When what I need is:
Heading1:--------Heading2:--------Heading3:
Total1------------Total2-----------Total3

Aliasing doesn't seem to want to work, it only applies to the first query in the union. Also.. having the heading in the adjacent column is not what I'm looking for. Any help or insight would be appreciated, cheers

 

[WayneRyan]

C,

The Union queries will never be spread out horizontally.

You'd have to make them individual queries and have a "final" query
put them into columns.

hth,
Wayne