Hi All,


I have

PRESTATION.DBF
Ifonctionid I && 1 Infirmière A1 - 2 Infirmière A2 - 3 Garde malade etc....( ne > 4 )
nHeures N(8,2)
ddate D

I Would like to know the total of the hours by function for one precise period.
This syntax do'nt Functions

  SELECT IIF( Ifonctionid = 1 , SUM( nheures ) , .T. ) AS "Infirmères",;
       IIF( Ifonctionid = 2 , SUM( nheures ) , .T. ) AS "Garde",;
       IIF( Ifonctionid = 3 , SUM( nheures ) , .T. ) AS "Para";
  	    FROM amline!prestation;
    WHERE  date  BETW  D_debut AND  D_Fin GROUP By ifonctionId INTO CURSOR Temp3
    
    SELECT temp3

Thanks in advance for help.
VFP 8 Pack1

bernhart