Hi sergey,

i don't understand.

How can i write it ?

bernhart


>Bernhart,
>
>When variable has logical value there's no need to compare it with .T. or .F.
>

>    SUM( IIF( E.Lassimilinami AND ( P.Iassimilid OR P2.Iassimilid ), ;
>H.n100 + H.n100_2 + H.n120 + H.n120_2 , 0.00 )) totHoAs ;

>
>
>>I try it...
>>
>>i must verify...
>>
>>

>>
>>  SELECT H.iemployeeid  ,;
>>    COUNT(*) totaljo ,;
>>    SUM( IIF( INLIST( .F. , E.Lassimilinami , P.Iassimilid , P2.Iassimilid ) , ;
>H.n100 + H.n100_2 + H.n120 + H.n120_2 , 0.00 )) totHoNAs ,;
>>    SUM( IIF( E.Lassimilinami = .T. AND ( P.Iassimilid = .T. OR P2.Iassimilid = .T. ) , ;
>H.n100 + H.n100_2 + H.n120 + H.n120_2 , 0.00 )) totHoAs ;
>>    FROM ;
>>    Horaire H INNER JOIN PAUSE P ON  H.cpauseid = P.iid ;
>>    INNER JOIN PAUSE P2 ON  H.cpauseid = P2.iid ;
>>    INNER JOIN Employee E ON  E.iid = H.iemployeeid;
>>    WHERE H.ddate BETWEEN D_debut AND d_fin ;
>>    GROUP BY 1;
>>    INTO CURSOR temp
>>
>>

>>
>>