>I ran the following code, which was working until I added an IIF statement in the select clause is giving me problems in compiling; it says it's missing a comma.
>
>

>	SELECT ;
>			ct.Name, cv.GrpID, cv.GrpNum, cv.Date, ;
>			cv.Seq, aa.EMP_ID, cv.CovCd AS PlanKey, ;
>			SPACE(8) AS BnftName, cv.PREM, cv.Bill_Date, ;

you've got an extra closing bracket/parenthesis before the AS

>			IIF (NOT EMPTY(aa.Depos_Date), cv.Prem, 0000000.00))  AS Collected ;

>	FROM BLCEXTAA aa ;
>	JOIN BLCEXTCV cv ;
>		ON aa.GrpID+aa.GrpNum+aa.Date+aa.Seq=cv.GrpID+cv.GrpNum+cv.Date+cv.Seq ;
>	JOIN GRPEXTCT ct ;
>		ON cv.GrpID=ct.GrpID ;
>	WHERE ;
>		aa.Stat_Code="P" AND ;
>		cv.GrpID=lcGrpID AND ;
>		cv.CovCd=lcPlanKey AND ;
>		YEAR(cv.bill_date)=2010 ;
>	ORDER BY cv.GrpID, cv.GrpNum, cv.CovCd ;
>	INTO TABLE tmpData
>