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?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05