Sequential Numbering

[Allan Martin]

Can I set up a field in Access 2000 to start numbering at
another number other than one? We need a field in our db
to generate an ID number and having it start at say 7500
and count up would really help.

 

[K*2]

-----Original Message-----
Can I set up a field in Access 2000 to start numbering at
another number other than one? We need a field in our db
to generate an ID number and having it start at say 7500
and count up would really help.
.

There's an article in the MS Knowledgebase that tells how
to do this using a query. Just do a seach on "reset
autonumber" and it will pop right up.

 

[Roger Carlson]

The Autonumber field is no good for sequential numbering as gaps can develop
between numbers. On my website is a small sample database called
"AutonumberProblem.mdb" that illustrates how to solve this.

 

[Allan Martin]

Article number 209696 in the Microsoft Knowledge Base
explains this well. We now want to use that number
elsewhere in the db. I'll post another question trying to
use the default value for that.