SELECT MONTH(date) as nmonth; , CMONTH(date) as smonth; , YEAR(date) as nyear; , sum(weight) as weight; , sum(iif(mode="L",1,0)) as bagsLC ; , sum(iif(mode="b",1,0)) as bagsLS ; from avlbook ; GROUP BY nyear,nmonth ; -- this is a implicit ORDER BY INTO CURSOR Temp