missing ID#8

[gpal]

Hello , I have a table with 22 entries and some how numberID 8 is missing . How can I get the numbers back in order without redoing the whole thing?
Thanks in advance, George

 

[John Big Booty]

If you are using the Auto Number function, then this and other oddities are will arise from time to time.

Ultimately the Auto Number should not be relied upon to provide anything other than a unique key. It is in essence not fit for human consumption.

If you require a consistent consecutive number, then have a look at the DMax() function plus one. Check this link for just one example of how this can be done.

 

[jdraw]

For a good read on Autonumbers see
http://www.utteraccess.com/wiki/index.php/Autonumbers