UNION QUERIES

  • Thread starter Thread starter AGOKP4
  • Start date Start date
A

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!!
 
Each column generated in a union query has only a single name/caption.
I'm not sure why you would want anything different.
 
AGOKP4 said:
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
Click to expand...
You can use a calculated column in each select:

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