Subject Re: [IBO] SQL
Author Svein Erling Tysvær
Hi Dion.

I'm surprised no-one has answered this seemingly simple question yet (at
least, I couldn't find any answer on Atkin):

SELECT SUM(Amount) AS TotAmount, c.CostItemName
FROM CostItem c
GROUP BY c.CostItemName

HTH,
Set