Auto Numbering field is skipping numbers. How do I fix it?

[Guest]

I am now in a new job and my predecessor set up this table with an Auto
Numbering funciton to automaticly assign customers' numbers. We have not yet
reached 300 in this table, and I have noticed that there are numbers skipped
in the Auto Number field (over 30 different numbers). I wonder if my
predecessor deleted these customers and in doing so erased the numbers from
use? Does anyone know if there is a way to fix this, or should I just ignore
it?

Thank you!

 

[fredg]

I am now in a new job and my predecessor set up this table with an Auto
Numbering funciton to automaticly assign customers' numbers. We have not yet
reached 300 in this table, and I have noticed that there are numbers skipped
in the Auto Number field (over 30 different numbers). I wonder if my
predecessor deleted these customers and in doing so erased the numbers from
use? Does anyone know if there is a way to fix this, or should I just ignore
it?

Thank you!

Ignore it.
Autonumbers need only be unique. There is no need for them to be
consecutive. Anytime you enter, and then delete, a record you will
have a gap. It doesn't matter.

 

[Joseph Meehan]

I am now in a new job and my predecessor set up this table with an
Auto Numbering funciton to automaticly assign customers' numbers. We
have not yet reached 300 in this table, and I have noticed that there
are numbers skipped in the Auto Number field (over 30 different
numbers). I wonder if my predecessor deleted these customers and in
doing so erased the numbers from use? Does anyone know if there is a
way to fix this, or should I just ignore it?

Thank you!

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.