My autonumber jumped out of seqence how do I get it back in order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My autonumber jumped out of sequence, example 79, 81 it did not go 79, 80
what happened? would appreiciate any help.

Thank You
 
It's likely that someone started entering a record after '79' and then
abandoned the entry (hit ESC). Access will not reuse that number.

You shouldn't use autonumber if you care about the value of the number.
 
Joan,
So is there anyway of re-setting these numbers in order?

Bill
Click to expand...

What part of this sentence in Joan's reply
You shouldn't use autonumber if you care about the value of the number<
Click to expand...
did you not understand?

Autonumbers need not be consecutive, only unique.
It needs to be unique so that each record can be identified by it's
unique, prime key field. But whether that number is 25 or 12326 is
irrelevant.
If a consecutive numbering system is needed don't use autonumber.
 
Please search this group for "AutoNumber", it gives hundreds or more posts
on this topic.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoNumber Field Limits - NOT "How do I reset?" 11
Opening form and going to a specific field in the middle of the from 1
How do I renumber a table? 2
AutoNumber, messed up sequence, duplicate values. 2
How do I get rid of "Auto Number" in forms ? 7
Part Autonumber 2
finding record from autonumber field 7
Autonumber field - increment 2

Back
Top