>thanks your reply
>
>SELECT date,code,lcode,sec, ;
> CAST(sum(IIF(category=="A",1,0)) AS I) A,;
> CAST(sum(IIF(category=="P",1,0)) AS I) P,;
> CAST(sum(IIF(category=="L",1,0)) AS I) L;
> FROM dlyatten;
>I want to count only record in this line
>CAST(sum(IIF(category=="A",1,0)) AS I) A,;
>If A in present in date(in sequential)1,2,3,4,5,6 dates Not count If 1,4,6,7

I'm sorry, but I don't understand. The best is if you can show us some data, and the result you want.