Auto fill records

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

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
 
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
 
Thanks Tom I'm using the number as a reference number to a set of records
that don't have one yet.
Tony
 
Back
Top