Start Autonumber field on number other than zero

[Melissa]

Hi there

I have created a db for a company who already has invoice numbers going. So
when they start to use the db, their invoice number cannot start from zero,
How would i set the "invoice number" to start on the number they are busy
with, eg: 280 ?

thank you

melissa

 

[Allen Browne]

Append a record 1 less than the number you wish to start from.

Details in:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

Alternatively, you can programmatically set the seed:
http://allenbrowne.com/func-ADOX.html#SetSeed

Note that is your database is split, you need to do this in the back end.