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

>
>