>Sergey,
>
>So just so that I understand this in the future: each field in the Group By is looking for exact matches. So, all those fields listed in the Group By have to be the same - and if they are, the SUM(payamt) is performed on those items. Correct?
>
>Mel Cummings
>

Yes, you'll get a record for each unique combinations of the fileds in GROUP BY clause.