COUNT(ncli) AS cnt_ncli, MAX(telno) AS last_telno FROM active ;&& every part pls. GROUP BY 1 INTO CURSOR telno READWRITE&& and this part REPLACE ALL active.Count1 WITH telno.cnt_ncli,active.Count2 WITH IIF(active.telno=telno.last_telno,telno.cnt_ncli,0)&& i'm not sure about it ,and what you mean with iif.thanks .