UNION QUERIES

[AGOKP4]

Hi All,

Is it possible to maintain individual group (row) headings after creating a
UNION query. I have manged to merge a group of queries but the headings for
each group was lost

Thanks!!

 

[Duane Hookom]

Each column generated in a union query has only a single name/caption.
I'm not sure why you would want anything different.

 

[Bob Barrows]

Hi All,

Is it possible to maintain individual group (row) headings after
creating a UNION query. I have manged to merge a group of queries
but the headings for each group was lost

You can use a calculated column in each select:

select 'group 1' as recordgroup,col1,...,coln from table ...
union
select 'group 2', ...