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"
SELECTdistinc b.date,b.code,b.category,;
(SELECTCOUNT(category="H") FROM (alias11);
WHERE b.date=date.and.year(date)=thisform.text1.Value);
FROM dlyatten B;
INTOCURSOR temp