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