> What is the cleanest method to test for records that have the same ID and combind them.
>
> Ex
>
> account# Address Item1 Item2 Total
>
> 7077 Address 5.00 5.00
> 7077 Address 5.00 5.00
>
>
> and make it
>
> 7077 Address 5.00 5.00 10.00
>
>
>
>
>
> Ryan J. Lashway
> http://www.lashtech.com

Select acctno, address, Cast(Sum(item1) As N(12,2)) As item1,;
	CAST(Sum(item2) As N(12,2)) As item2,;
	CAST(Sum(Total) As N(12,2)) As Total;
	FROM yourtable Group By acctno, address

Jun Tangunan
http://weblogs.foxite.com/sandstorm36/