Auto numbering gone haywire

[sunserve]

I was entering records using a form and all was well until suddenly the autonumbering went from 7 to 14! I went into the table and deleted #14 and tried it again - same thing happened.

 

[KenHigg]

Sounds like you are depending on the autonnumber feature to provide you with a record count... And this is generally badd juju...

 

[Pat Hartman]

Autonumbers can skip values for a variety of reasons. This is not a problem since autonumbers should only be used to provide unique identifiers.

 

[sunserve]

Is there a way to make autonumbering consecutive?

 

[RuralGuy]

The simple answer is *NO*! If you need consecutive numbers then you need to develop your own function.