>CLOSE DATABASES > >USE c:\fmsrun\prompt\EligAct IN 0 > >m.DOSBegin = DATE() -30 >m.DOSEnd = DATE() > >SELECT ; > ICASE(; > MONTH(DOSBegin)= 1,'Jan',; > MONTH(DOSBegin)= 2,'Feb',; > MONTH(DOSBegin)= 3,'Mar',; > MONTH(DOSBegin)= 4,'Apr',; > MONTH(DOSBegin)= 5,'May',; > MONTH(DOSBegin)= 6,'Jun',; > MONTH(DOSBegin)= 7,'Jul',; > MONTH(DOSBegin)= 8,'Aug',; > MONTH(DOSBegin)= 9,'Sep',; > MONTH(DOSBegin)=10,'Oct',; > MONTH(DOSBegin)=11,'Nov',; > MONTH(DOSBegin)=12,'Dec') AS MonthName, ; > COUNT(*) AS DOSCnt ; > FROM EligAct ; > WHERE BETWEEN(EligAct.DOSBegin,m.DOSBegin,m.DOSEnd) ; > GROUP BY MonthName ; > INTO CURSOR ReportCursorSummary > >BROWSE LAST > >CLOSE DATABASES >