>>Is this being performed on a cursor by chance? If so, reccount() may not return the correct value unless you use the NOFILTER parameter in your query. However I would also reccomend using Scan/Endscan instead of the For/Skip as John has suggested.
>>
>>>The reccount() is not working.
>>>Here is my code:
>>>
>>>i=1
>>>for i=1 to reccount()
>>> replace myfld with i
>>> if !eof()
>>> skip
>>> endif
>>>endfor
>>>
>>>What I want to do is change the value of myfld in all the records in the table. This FOR LOOP will not do that.
>>>any ideas?
>
>If you're trying to fill the myfld field with the record number, you could simply do:
>
>Replace All myfld With RecNo()
>
>HTH
-----
thanks Chad.. :)