Can you set Autonumber to start with zero?

  • Thread starter Thread starter CES
  • Start date Start date
C

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
 
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 said:
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
Click to expand...
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
 
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
 
"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...
 
"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...
Click to expand...

.... with longbows properly normalized of course!

John W. Vinson[MVP]
 
"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.
 
Back
Top