Prev: Combining Two Fields in One Calculated Field
Next: what causes, "no results returned"
From: jeffhill on 2 Apr 2010 19:49
While entering records into database, I entered the same record two times. I
deleted the record with the duplicate information and then added a new
record. Now the values in the AutoNumber field are not sequential. How can
this be?
From: Steve on 2 Apr 2010 20:08
At the first data entry keystroke of a new record, Access assigns the
autonumber which is the highest existing autonumber +1. Access never goes
back and trys to assign a missing autonumber. When you delete a record,
Access deletes the assigned autonumber and that number is gone forever never
to be reused.

Steve
santus(a)penn.com


"jeffhill" <jeffhill(a)discussions.microsoft.com> wrote in message
news:67ED57E8-277B-4945-8115-EDEF223F28A7(a)microsoft.com...
> While entering records into database, I entered the same record two times.
> I
> deleted the record with the duplicate information and then added a new
> record. Now the values in the AutoNumber field are not sequential. How can
> this be?


From: Richard on 2 Apr 2010 20:24
Auto numbers are meant to increment, but not necessarily are sequential.

Richard

"jeffhill" wrote:

> While entering records into database, I entered the same record two times. I
> deleted the record with the duplicate information and then added a new
> record. Now the values in the AutoNumber field are not sequential. How can
> this be?
From: fredg on 2 Apr 2010 20:25
On Fri, 2 Apr 2010 16:49:01 -0700, jeffhill wrote:

> While entering records into database, I entered the same record two times. I
> deleted the record with the duplicate information and then added a new
> record. Now the values in the AutoNumber field are not sequential. How can
> this be?

That's the way AutoNumbers work. Once a number is assigned to a new
record, if you delete that record that number is not re-used. Even
without deleting a record, AutoNumbers are only required to be unique,
not sequential, and gaps can occur.
If, for some reason, you need to have a sequential number, you'll have
to create your own system. But again, once you delete a record, let's
say record #54 out of a sequence of 1 to 100, you will still have a
missing number.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
From: Douglas J. Steele on 3 Apr 2010 13:26
In addition to what everyone else has told you, why does it matter?

The only reason for an AutoNumber field is to provide a (practically
guaranteed) unique value that can be used as a primary key. 231, 233, 234
serves that need just as well as 1, 2, 3. If the value of the AutoNumber
field matters to you, you probably shouldn't be using an AutoNumber field.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"jeffhill" <jeffhill(a)discussions.microsoft.com> wrote in message
news:67ED57E8-277B-4945-8115-EDEF223F28A7(a)microsoft.com...
> While entering records into database, I entered the same record two times.
> I
> deleted the record with the duplicate information and then added a new
> record. Now the values in the AutoNumber field are not sequential. How can
> this be?


 |  Next  |  Last
Pages: 1 2
Prev: Combining Two Fields in One Calculated Field
Next: what causes, "no results returned"