my mistake


i mean evrey flage have no from 1 to the last records

flag=1 from 1 to 145...replace no with recno() all
flage=2 from 1 to 450
flage 3....

.
.
.
falg=9 from 1 to 870 at my table
thanks,


>hi all,
>
>i have table have more 20000 records
>
>have fields as flag from 1 to 9,
>
>i need to replace all fields have flage= 1 numbers from 1 to the last record have flage= 1 as ex.. 145
>
>flage= 2 take numbers from 146 to end flage=2 as last record is 445
>
>flage= 3 from 446...etc
>
>thanks