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



"jeffhill" wrote in message
...
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?