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
>You would group on all of them
SELECT employeid, lastname, firstname, payamt, ;
paydate, payhow, checknum, SUM(payamt) ;
FROM appdata!mydata ;
GROUP BY employeid, lastname, firstname, payamt, ;
paydate, payhow, checknum