Autonumber starting point

[Guest]

Can someone tell me how make an autonumber field begin at a predetermined
starting point? For example, I want the number to begin numbering at 100
instead of at 1. There's a way to change the increment for each record's
autonumber as well, but I don't remember how. Thanks in advance.

 

[Guest]

You can't change the increment of an autonumber to something like 5, 10, 15,
20, etc. While you can start an autonumber at 100, you can't control if
Access suddenly wants to make the next number 22, 1 or even -100.

Autonumbers are only garenteed to be unique IF that field is also a Primary
Key (Even then there's a little bug that can mess that up). If you need your
numbers to be a certain sequence, especially without breaks as in an
invoice#, autonumber isn't the right tool.

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[AaronKempff]

You can't change the increment of an autonumber to something like 5, 10, 15,
20, etc.

Oh yeah?

http://support.microsoft.com/kb/202121/

ACC2000: Cannot Change Default Seed and Increment Value in UI

"To resolve this problem, you can use Data Definition Language (DDL)
to create a table with an Identity column that has the seed and the
increment values that you want, other than the default value of one."

Use ADO. Set the autonumber increment value to anything you like. Use
DAO and live in the 1990s. Pick two. Aaron Kempff - MDB guru.

 

[Tom Wickerath]

yes you can do this

it is called Acccces Data Projects and you can set the seed and the
increment values of an identity integer field