Id's in table not consistent

[SheepDog]

I have a table that has a column for id's that are auto generated when a new record is added.
There were sequential up to 3107 and have jumped to 3112. Now when a record is added they increment by 2 instead of 1 can any one help me figure out the problem?

 

[nicsin]

Autonumbers are generated sequencially. This means that if something goes wrone and the insert is aborted or if a record is deleted then you will have gaps. that shouldn't be a proble since you have uniqueness and the latest record inserted has the largest ID.

 

[MichaelRed]

It is possible -in the later versions of Ms. A.- to set the "delta" or incrtement value of the "AutoNumber" field, which MAY account for the increment by 2. nicsin is correct re the missing numbers.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[SheepDog]

Using Access 2000 I will look but have not noticed the term "Delta".

 

[SheepDog]

Here is a question for you a little different
I have a text box that I need a mask of SCHH and another text box with a mask of SCHS. Can I make make a mask on the properties of the text box or table since both offer this?

What characters make the uppercase letters I have above?