a make table union query with a group by, possible??

  • Thread starter Thread starter lexx
  • Start date Start date
L

lexx

I want to run a union query that has a group by on the
DebtorName and I can't get it to work any ideas. also
any way to get this to run as a make table query as well??

thanks
lexx

here is what I have

SELECT ClaimOfLien.DebtorName, ClaimOfLien.DebtorAddress,
ClaimOfLien.DebtorCity, ClaimOfLien.DebtorState,
ClaimOfLien.DebtorZIP
FROM ClaimOfLien;
UNION Select Claimoflien.POwnerName,
Claimoflien.POwnerAddress, Claimoflien.POwnerCity,
Claimoflien.POwnerState, Claimoflien.POwnerZIP
From ClaimofLien;
UNION Select Claimoflien.P2OwnerName,
Claimoflien.P2OwnerAddress, Claimoflien.P2OwnerCity,
Claimoflien.P2OwnerState, Claimoflien.P2OwnerZIP
From ClaimofLien;
UNION Select Claimoflien.P3OwnerName,
Claimoflien.P3OwnerAddress, Claimoflien.P3OwnerCity,
Claimoflien.P3OwnerState, Claimoflien.P3OwnerZIP
From ClaimofLien;
 
I want to run a union query that has a group by on the
DebtorName and I can't get it to work any ideas. also
any way to get this to run as a make table query as well??
Click to expand...

I think you'll need to save the UNION query, and then base a Totals
query *on the Union query*. The Totals query can be made into a
MakeTable query - but you'll need two queries at least, the UNION and
another one built upon it.
 
Back
Top