Auto fill records

[Tony Williams]

I have a database with just over 200,000 records I have a number field that
is ca;led semitarrefnbr. I want to autofill this field with a number
starting with 1. How do I do this? I've already got one Autonumber field
being used as the Primary Key so I can't use Autonumber, (at least I don't
think I can?)
Thanks
Tony

 

[Tom van Stiphout]

On Sat, 20 Dec 2008 15:06:22 -0000, "Tony Williams" <[email protected]>
wrote:

You could copy the autonumber value into it using an Update query.
Or write some VBA to populate the field.
But first ask yourself if you really need a sequential number field.
It is rarely a good idea.

-Tom.
Microsoft Access MVP

 

[francesco]

manda in italiano i messaggi

 

[Tony Williams]

Thanks Tom I'm using the number as a reference number to a set of records
that don't have one yet.
Tony