CLOSE DATABASES USE c:\fmsrun\prompt\EligAct IN 0 m.DOSBegin = DATE() -720 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 ReportMonth, ; YEAR(DOSBegin) AS ReportYear, ; COUNT(*) AS DOSCnt ; FROM EligAct ; WHERE BETWEEN(EligAct.DOSBegin,m.DOSBegin,m.DOSEnd) ; GROUP BY ReportYear, ReportMonth ; INTO CURSOR ReportCursorSummary BROWSE LAST CLOSE DATABASES CANCEL
Oct 2007 2 Aug 2008 9 Feb 2008 4 Jul 2008 3 Sep 2008 20