Jay,

Try removing the asterisk in the COUNT()....

HTH
Dennis


>UPDATE: Doh! I forgot the last condition in the ICASE.
>
>I'm getting an error "Cannot determine data type of the expression." on the SQL below.
>

>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
>