reset autonumber

[viperstingray]

just a small question. I have a database that assigns a unique 'audit id' to each entry. the ID is in the form of : DEA-[client prefix]-autonumber. Everything is working fine except the autonumber part. I have gaps in the numeric sequence. Ex: DEA-AAA-1, DEA-AAA-2, DEA-AAA-8, DEA-ABC17, etc.

is there a way that I can reset this autonumber so that it may look like this:
Ex: DEA-AAA-1, DEA-AAA-2, DEA-AAA-3, DEA-ABC4, etc.

 

[directormac]

Again??!??!!

Did you search the forum archives before posting this? I'm guessing not, because this topic has been discussed in HUNDREDS of posts, including this one.

If you are using them as intended, gaps in autonumber sequences mean nothing. If not having blanks is important, then you should not be using autonumbers.


--Tired Mac

 

[viperstingray]

i did search the post and I could not find exactly what I was looking for. the autonumber does not really make a difference, it would just be nice to have if they were in sequence. Thanks for the link though.