Bernhart,

You could try something like:

SELECT COUNT(*) AS lnCnt , SUM(IIF(iemployeeid = 143,1,0)) ;
 FROM Trimestre_Lignes WHERE !DELETED() INTO CURSOR temp

Cheers,

Zoran

>Hi All,
>
>I would like to create only one requery which gives me two result.
>
>Firstly the number of records.
>Secondly the Number of record for which iemployeid = 143.
>
>I have difficult To find the Good code.
>
>

> SELECT COUNT( RECNO() ) AS lnCnt , COUNT(iemployeeid = 143 ) ;
>  FROM Trimestre_Lignes WHERE !DELETED() INTO CURSOR temp
>

>
>Thank in advance for the answer.
>
>bernhart