Dear all
i am trying to using these sql codes for counting.
in a category field has three diffirent replacment. "A","P","H"
i want to count , what i am doing wroung
spshilay this codes
SELECT COUNT(category="H"

SELECT  distinc b.date,b.code,b.category,;
                    (SELECT COUNT(category="H") FROM (alias11); 
                    WHERE b.date=date.and.year(date)=thisform.text1.Value);
                         FROM dlyatten B;
                         INTO CURSOR temp

Note:i have been chose other topic.