>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

What do you mean [When a "code" with "date" have 6 "A"]?

Do you mean [When same code is in 6 records with cat="A"]?

Where does the date field come into it? In your example there are 6 different dates.