Consolidate data in rows depending on Month and Organisation

[scoe]

Hi, I hope someone can help... I am preparing a query for a report that is quite detailed and have produced a union query which contains the information but does not put it all in one row depending on month and organisation, I have tried various methods but nothing seems to work.... Desparate for help on this.

orgn_name	MonthDesc	CINT	WthT	TranT	EnrT	CompT
Clarity Education	August				3
Clarity Education	December				7
Clarity Education	December	1
Elite Assessors Ltd	November				10
Elite Assessors Ltd	November	1
Elite Assessors Ltd	October				1

The code is:
[SELECT [Apps Post In Summary By Partners].orgn_name, [Apps Post In Summary By Partners].MonthDesc, Count([CIN]) AS CINT, "" AS WthT, "" AS TranT, "" AS EnrT, "" AS CompT
FROM [Apps Post In Summary By Partners]
WHERE ((([Apps Post In Summary By Partners].CIN)="CIN"))
GROUP BY [Apps Post In Summary By Partners].orgn_name, [Apps Post In Summary By Partners].MonthDesc, "", "", "", "";Union
SELECT [Apps Post In Summary By Partners].orgn_name, [Apps Post In Summary By Partners].MonthDesc, "" AS CINT, Count([Apps Post In Summary By Partners].[Withdrawals]) AS WthT, "" AS TranT, "" AS EnrT, "" AS CompT
FROM [Apps Post In Summary By Partners]
WHERE ((([Apps Post In Summary By Partners].Withdrawals)="Withdrawal"))
GROUP BY [Apps Post In Summary By Partners].orgn_name, [Apps Post In Summary By Partners].MonthDesc, "", "", "", "";Union
SELECT [Apps Post In Summary By Partners].orgn_name, [Apps Post In Summary By Partners].MonthDesc, "" AS CINT, "" AS WthT, Count([Apps Post In Summary By Partners].[Transfers]) AS TranT, "" AS EnrT, "" AS CompT
FROM [Apps Post In Summary By Partners]
WHERE ((([Apps Post In Summary By Partners].Transfers)="Transfer"))
GROUP BY [Apps Post In Summary By Partners].orgn_name, [Apps Post In Summary By Partners].MonthDesc, "", "", "", ""; UNION SELECT [Apps Post In Summary By Partners].orgn_name, [Apps Post In Summary By Partners].MonthDesc, "" AS CINT, "" AS WthT, "" AS TranT, Count([Apps Post In Summary By Partners].[Enrolments]) AS EnrT, "" AS CompT
FROM [Apps Post In Summary By Partners]
WHERE ((([Apps Post In Summary By Partners].Enrolments)="Enrolment"))


GROUP BY [Apps Post In Summary By Partners].orgn_name, [Apps Post In Summary By Partners].MonthDesc, "", "", "", "";]

Any help would be gratefully appreciated

[scoe]

Used the union query to make a new select query and used max on all columns bar the [MonthDesc]and [orgn_name] and the report has excepted this and has consoidated the columns.