autonumber new table from 2500

[Nigel]

Hi,

i am creating a database and i'm not that experienced at present. i a
mcreating tables ok but cannot get around this problem. as i am planning on
transferring my existing Excel system into a database, i needto start my
future project numbers from my old system. i am currently on number 2410.
this number goes in sequence for every new project / enquiry. so my question
is:

how can i start a table auto number from the number 2500 without placing the
two thousand four hundred & ninety nine numbers before it???


thanks,


Nigel

 

[Duane Hookom]

You can create a table with one numeric field and one record. Edit the value
of the one field and set it to 2499. Append this record to your existing
autonumber field. Then delete the record. The next record you would add to
the table will now have an autonumber value of 2500.

I generally recommend against using the autonumber fields for anything other
than creating a unique primary key.

 

[Pat Hartman\(MVP\)]

This is a unique primary key. The poster simply doesn't want it to
duplicate existing data.

Nigel,
If you want to append your existing data, just make sure to map the existing
project number to the new autonumber field. That will allow the sequence to
pick up where your spreadsheet left off without having to add and then
delete a dummy record.