divi="تعبئة/كوابل" AND divi="تلبيس/كوابل" AND....... ;
SET TALK OFF SET ECHO OFF SET SAFETY off CLOSE all USE table1 m.dat1=DATE(2005,1,1) m.dat2=DATE(2005,12,31) 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)=1 AND typ <= 2, INT(CTOT(true) -CTOT("00:00")), 000000)) AS m1_t, ; 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)=2 AND typ <= 2, INT(CTOT(true) -CTOT("00:00")), 000000)) AS m2_t, ; SUM(IIF(MONTH(dat)=3 AND typ = 1, INT(CTOT(true) -CTOT("00:00")), 000000)) AS m3_m, ; SUM(IIF(MONTH(dat)=3 AND typ = 2, INT(CTOT(true) -CTOT("00:00")), 000000)) AS m3_a, ; SUM(IIF(MONTH(dat)=3 AND typ <= 2, INT(CTOT(true) -CTOT("00:00")), 000000)) AS m3_t, ; SUM(IIF(typ = 1, INT(CTOT(true) - CTOT("00:00")), 000000)) AS tot_m, ; SUM(IIF(typ = 2, INT(CTOT(true) - CTOT("00:00")), 000000)) AS tot_a, ; SUM(IIF(typ <= 2, INT(CTOT(true) - CTOT("00:00")), 000000)) AS tot_t, ; SUM(IIF(typ >= 4, INT(CTOT(true) - CTOT("00:00")), 000000)) AS tot_tot ; FROM table1 ; WHERE dat BETWEEN m.dat1 AND m.dat2 AND divi="تعبئة/كوابل" AND divi="تلبيس/كوابل" ; GROUP BY 1,2; ORDER BY 1, 2; INTO table curbilldata USE curbilldata BROWSE NORMALthanks