You're welcome.

>thank you very much,it works
>
>>I guess you understand that I don't have the chance to test the code I give you for free, and I do expect you to understand my code and fix it accordingly. However, try this

>>local lnNumber, lnFlag
>>INDEX ON offer TAG offer && Why, why, why do you have this line? If you need an index tag, you create it ONCE, and it stays!
>>Use ANALYSIS1 order offer
>>go top
>>lnNumber=1
>>lnFlag=offer
>>do while !eof()
>>  replace no with lnNumber
>>  skip
>>  if offer=lnFlag
>>    lnNumber=lnNumber+1
>>  ELSE
>>    lnNumber=1
>>    lnFlag=offer
>>  endif
>>enddo

>>