Change Starting Value in an Autonumber field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to import records to a new table but start over the record numbering from "1" (i.e. the records from the previous table keep their numbers but any new entries start from 1, 2, 3 etc.). I've followed the Access Help instructions and still have a problem. I think there must be something else not mentioned in the instructions that I'm not doing. Any suggestions?
 
-----Original Message-----
I need to import records to a new table but start over
Click to expand...
the record numbering from "1" (i.e. the records from the
previous table keep their numbers but any new entries
start from 1, 2, 3 etc.). I've followed the Access Help
instructions and still have a problem. I think there must
be something else not mentioned in the instructions that
I'm not doing. Any suggestions?
.
Click to expand...

Reply,

Autonumber does exactly what it says, Nothing else. The
reason why it is there is to make sure you don't get
identical records if requested. If you try and use it in
records you will find that it will not keep a consecutive
order.

The only way is to write a procedure that opens a table
and gets the next number and then write's the new
number. Look at macro's or VBA for help
 
Back
Top