>I am converting a program from VFP to SQL with ado.
>
>I seems that the sql statements are not compatible.
>The SUM with an IIF statement does not give the correct result
>
>Example
>
>select *, sum(uurfact) as fact, SUM(IIF(ureisk='Ja ',1,0)) as reisk from uren where umcode= '20002 ' group by umcode
>
>Can someone help me.
>
>Kind regards
>
>
>Jan Dorresteijn
IIF is a VFP command and not recognized by SQL Server.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer