auto number starting from 1 million

[mfpoore]

I need to add a autonumber field to a table from which I built a form. The problem is I have assigned numbers and it must start from 1000000 and number up from there instead of starting with one.
Any help greatly appreciated!
mfpoore

 

[a.sinatra]

What is so wrong about using 1?
________
Indica strains

 

[Parker]

I need to add a autonumber field to a table from which I built a form. The problem is I have assigned numbers and it must start from 1000000 and number up from there instead of starting with one.
Any help greatly appreciated!
mfpoore

If you do a search there are loads of examples/answers to this question ..... look at re numbering autonumber fields and then start your autonumber wherever you like

 

[mfpoore]

got it,
thanks