In my table"dly" have fileds "code,date,cat" In cat filed I am inserintg "A" ,"P"
I want to count the records If:
When a "code" with "date" have 6 "A" How to count this like this

code date cat
111 21/08/07 A
111 22/08/07 A
111 23/08/07 A
111 24/08/07 A
111 25/08/07 A
111 26/08/07 A