Auto Number

[Guest]

Hi

I created a new database with all my required tables etc.

The Ref # in the table is set to autonumber. The table name is "Trade Data"
However I created a new database called "Trade Data Cont'd" and the table
structure would remain the same as the orignal Trade Data table. However the
last record in the Trade Data table is 619 and I wish to have the record in
the new table start at 620 using the Auto Number format. However this does
not work as the table starts at 1 again. Is it possible to have this new
table start at 620. If so, what would need to be done.

Thanks

 

[Guest]

Hi,

One way to achieve this is to enter 619 records (create an append query and
loop through it 619 times) and then delete all the reocords. Now you can
start entering records with your auto number starting at 620.

Regards,

 

[Guest]

No looping required if you append a record with 619 in the autonumber field
and something else in another field. You can then deleted the one record and
the numbers will continue as long as you do not compact before entering
additional records.

Why are you creating a new database like this? If you need separation then
add a flag field as a separation indicator like FY or some such. Then all
your data is available if need be.

 

[BruceM]

You can get the autonumber to start from 620 as described, but be aware that
gaps in the autonumber sequence are almost ineveitable. If you need
sequential numbering you should not be using autonumber. You certainly
should not be using it if you are creating records that may be audited,
which would leave you trying to explain gaps in the numbering sequence.
Autonumber is for Access to use. The user should not see it.