Sums in First Column of Crosstab

[JRINC]

How can I get the query to sum column 1 (EventName) so there is one row for each individual event? (EventName data is months of the year plus a few other meeting names). Now it creates a row each time, for example, there is an expense for that event. So one month might be listed many times...

Thanks!





TRANSFORM CCur(Nz(Sum([Expense Details].Cost),0)) AS [Total Of Cost]
SELECT [Expense Details].EventName
FROM [Expense Report] INNER JOIN ([Expense Details] INNER JOIN [Budget Categories] ON [Expense Details].CategoryNumber=[Budget Categories].ID) ON [Expense Report].ExpenseID=[Expense Details].ExpenseReport
GROUP BY [Expense Report].ExpenseDate, [Expense Details].EventName
PIVOT [Budget Categories].CategoryNumber;

[June7]

I need sample data to test on if you want to provide.