Hi Robert ---

Are you trying to replace myfld with the recordnumber? Or just a unique number?
If the record number:

REPLACE ALL myfld WITH RECNO()

If a unique number (a counter):

n=1
SCAN
   REPLACE myfld WITH n
   n=n+1
ENDSCAN

OK?

>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?