... Sec2Str(SUM(IIF(MONTH(dat)=1 AND typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000))) AS m1_m, ; Sec2Str(SUM(IIF(MONTH(dat)=1 AND typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000))) AS m1_a, ; ... ... FUNCTION Sec2Str LPARAMETERS tnSeconds RETURN TRANSFORM( RIGHT( TTOC(CTOT("00:00") + tnSeconds,1), 6), "@R 99:99:99") >thank you very much, it works but... >i need to change seconds to hours and minuts inside the code >how i can sum m1_m,m2_m ....m12_m to new field >and sum m1_a, m2_a.........m12_1 to new filed ><pre> >CLOSE all >USE table1 >INDEX ON divi TO kk >m.dat1=ctod("01/01/2005") >m.dat2=ctod("01/31/2005") >SELECT divi, mac1, ; > SUM(IIF(MONTH(dat)=1 AND typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m1_m, ; > SUM(IIF(MONTH(dat)=1 AND typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m1_a, ; > SUM(IIF(MONTH(dat)=2 AND typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m2_m, ; > SUM(IIF(MONTH(dat)=2 AND typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m2_a, ; ... > SUM(IIF(MONTH(dat)=11 AND typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m11_m, ; > SUM(IIF(MONTH(dat)=11 AND typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m11_a, ; > SUM(IIF(MONTH(dat)=12 AND typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m12_m, ; > SUM(IIF(MONTH(dat)=12 AND typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000)) AS m12_a ; >FROM table1 ; >WHERE dat BETWEEN m.dat1 and m.dat2 ; >GROUP BY 1,2 >**skip >