Your problem looks like running total problem, which is slightly complex.

It may be better to do this using procedural code in your case.

>HI SERGEY,
>
>Thank for help.
>
>if i want in the same command increment ( cf attachment nincrement.jpg ) ..
>it 's possible ?
>
>bernhart
>
>
>>

>>SELECT cnomres, COUNT(*) FROM mytable GROUP BY 1
>>

>>>
>>>
>>>How to count records in a sql clause ?( VFP 9.2 )
>>>ie Here i want 2 For ncount Value To "GROGNA Denise"
>>>3 For Houbrechts Anna
>>>
>>>How to count a field?
>>>
>>>
>>>Thank in advance and good evening
>>>
>>>BHT