I have a union query
SELECT CLIENT.ID, CLIENT.[First Name], CLIENT.[Last Name], CLIENT.[Team], CLIENT.[Referral date], CLIENT.[Closed date]," " as SDQ_Tot, " " as SDQ_P, " " as SDQ_C, " " as SDQ_O, " " as SDQ_T, " " as SDQ_S
FROM CLIENT
UNION
SELECT CROSSTAB_SDQ.ID, " ", " ", " ", " ", " ", CROSSTAB_SDQ.[Total], CROSSTAB_SDQ.P, CROSSTAB_SDQ.C, CROSSTAB_SDQ.O, CROSSTAB_SDQ.T, CROSSTAB_SDQ.S
FROM CROSSTAB_SDQ;
that returns
ID F name L Name Team Date 1 Date 2 Tot P C O T S 1 3 1 2 1 Bill Duck X 1/1/1900 2/2/2000 2 5 1 3 1 2 Bob Weave Y 1/1/1900 2/2/2000
However, I need
ID F name L Name Team Date 1 Date 2 Tot P C O T S 1 Bill Duck X 1/1/1900 2/2/2000 3 1 2 2 Bob Weave Y 1/1/1900 2/2/2000 5 1 3 1
Is that possible to achieve?
Then I want to add more unions to that query (there are a number of other counts and totals I need to bring in).
Thanks,
Rramjet.