Autonumber starting from 500

[Ann Shaw]

Hi

I have a database and I want to create a new table with an
Autonumber that will start not at 1 but at 500 is this
possible? Any help would be greatly appreciated.

Many thanks and kind regards

Ann (Dublin, Ireland)

 

[Roger Carlson]

Yes, this is possible. You can find the procedure in Access Help. Type
'Autonumber' in the Keyword of Help, then scroll down the list till you find
"Change the starting value of an incremental Autonumber field".

However, you SHOULD NOT CARE what the value of an autonumber field is!
Autonumber fields should not be used to store information (invoice number,
etc.) You have no control over an Autonumber and the sequence can easily
develop gaps. If you MUST have a sequential number, you should create it
yourself in code.

On my website (www.rogersaccesslibrary.com) is a small sample database
called "AutonumberProblem.mdb" which illustrates one way to do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Brian]

Hi

I have a database and I want to create a new table with an
Autonumber that will start not at 1 but at 500 is this
possible? Any help would be greatly appreciated.

Many thanks and kind regards

Ann (Dublin, Ireland)

http://support.microsoft.com/default.aspx?scid=kb;en-us;209696

 

[Ann Shaw]

Many thanks Roger for you help!

-----Original Message-----
Yes, this is possible. You can find the procedure in Access Help. Type
'Autonumber' in the Keyword of Help, then scroll down the list till you find
"Change the starting value of an incremental Autonumber field".

However, you SHOULD NOT CARE what the value of an autonumber field is!
Autonumber fields should not be used to store information (invoice number,
etc.) You have no control over an Autonumber and the sequence can easily
develop gaps. If you MUST have a sequential number, you should create it
yourself in code.

On my website (www.rogersaccesslibrary.com) is a small sample database
called "AutonumberProblem.mdb" which illustrates one way to do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe? SUBED1=ACCESS-L





.