Sequential Numbering

[Allan Martin]

Can I set up a field in Access 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.

 

[Joan Wild]

You can set the autonumber to start at a specific number, however you really
have no control over the autonumber. It can skip numbers, and even become
random. To implement what you want, have a look at
How to Create a Multiuser Custom Counter
http://support.microsoft.com/?kbid=210194