FOR nMonth = 1 TO 12
	lcMonth = CMONTH(DATE(YEAR(DATE()),m.nMonth,1))
	ldFirstDayOfMonth = DATE(YEAR(DATE()), m.nMonth,1)
	ldLastDayOfMonth = IIF( nMonth < 12,  DATE(YEAR(DATE()), m.nMonth+1,1)-1 ,  DATE(YEAR(DATE()),12,31))

	SELECT lcMonth+" 2010" AS Month_Year, ;
		GrpID, ;
		Emp_ID, ;
		SUM(bill_prem) AS Month_Billed, ;
		BnftName, ;
		0000000.00 AS Month_Collected ;
	FROM tmp1 ;
	WHERE BETWEEN(bill_date, m.ldFirstDayOfMonth, m.ldLastDayOfMonth);
	INTO CURSOR ("tmp" +TRANSFORM(m.nMonth));
	GROUP BY GrpID, Emp_ID, BnftName

ENDFOR
>