Hi Guys,

Ok I have a data table containing duplicate Reciept numbers and a transaction value for each record, I need to simply list the total for each unique Reciept number, this is obviously a simple problem but I am missing something.

Any help is much appriciated

>  SELECT Gf_Receipt_number AS Reciept,
> SUM (Gf_Amount) AS Total   FROM
> [TestP].[dbo].[Gf]   WHERE
> Gf_Receipt_number IS NOT NULL   GROUP
> BY Gf_Amount

Would probably help to mention the the error I am recieving is:

Column 'TestP.dbo.Gf.Gf_Receipt_number' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.