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