Can you set Autonumber to start with zero?

[CES]

All,
I was wondering if it is possible to set an autonumber field to start with zero instead of one or for that matter any other number other than one?

Thanks in advance. - CES

 

[Jeff Boyce]

CES

Access "Autonumbers" are intended for use as unique row identifiers. They
have no inherent meaning, may appear to "skip" some numbers in sequence, may
be random rather than quasi-sequential, and are generally unfit for human
consumption.

If you want to "set" an autonumber field to a particular value (e.g., "0"),
use a different numbering routine. Check mvps.org/access for "Custom
Autonumber" for one way to do this.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[CES]

CES

Access "Autonumbers" are intended for use as unique row identifiers. They
have no inherent meaning, may appear to "skip" some numbers in sequence, may
be random rather than quasi-sequential, and are generally unfit for human
consumption.

If you want to "set" an autonumber field to a particular value (e.g., "0"),
use a different numbering routine. Check mvps.org/access for "Custom
Autonumber" for one way to do this.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,
Thank for your help Jeff... you indicated that there is a better way of doing a custom autonumber, I searched mvps.org and founder of the article "Have Autonumber field start from a value different from 1" which answered my question but was unable to find any articles on doing an auto number without using a data type of autonumber.
Is there a specific article on using a different numbering routine to set up the equivalent of an autonumber data type. -- CES

 

[Jeff Boyce]

Sorry 'bout that, I was sure mvps.org/access had a "custom autonumber"
routine.

Try searching via Google.com (or another search engine) using that phrase.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tom Wickerath]

Jeff,

One of our MVP brothers, Roger Carlson, has a sample posted on his web site:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Fred Boer]

"We few, we happy few, we band of brothers..."

.....comes irresistibly to mind....

Cheers!
Fred

P.S. And, in addition, a rather odd mental image of MVP's clad in Lincoln
green, cheering as they are urged on into battle...

 

[John Vinson]

"We few, we happy few, we band of brothers..."

....comes irresistibly to mind....

Cheers!
Fred

P.S. And, in addition, a rather odd mental image of MVP's clad in Lincoln
green, cheering as they are urged on into battle...

.... with longbows properly normalized of course!

John W. Vinson[MVP]

 

[mnature]

"Be he ne'er so vile"

And St. Crispin's Day is soon to come. I must remember to post the speech
that day, as is my wont.