>in my filed (category) records as=A,B,C,A,A,A
>I want to count the records.
>if A,A,A is replaced continuously

>SELECT date,code,lcode,sec, ;
> CAST(sum(IIF(category=="A",1,0)) AS I)	A is 3

Select myTable.*, AddSQL.CatCount from myTable ;
inner join (select Category, count(*) as CatCount ;
from myTable group by 1) AddSql on myTable.Category = AddSql.Category