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