It's good he clarified, because serial number rings another bell and I was trying to think how can he replace it in a table <g>

>>hi,
>>thank you
>>
>>i have table with many records and epmty filed as NO,
>>i need replace no.1 for first record no.2 for next record ..to end table
>>thanks
>
>

REPLACE Field1 WITH RECNO() ALL