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