auto number

[Souris]

I have a auto number field which works.
Since I am on the test step, I need reset it while I am testing.

any way to reset to 0.

Thanks in advance,

 

[Jerry Whittle]

Delete all the records in that table then do a compact and repair.

HOWEVER if you expect autonumbers to be sequential and without breaks, you
may well be disappointed. If used as a primary key, autonumbers are only
guarenteed to be unique. The number could skip a few and, in fact, there are
ways that users could burn through numbers such as opening a new record but
deciding not to complete it.

 

[Larry Daugherty]

There are ways to do that but I've never bothered to master any of
them. The Autonumber datatype exists for the sole purpose of
generating unique, Long Integer, values to serve as surrogate Primary
Keys. They should not be used to imply any human usable intelligence.
If they are invested with meaning then they are being miss-used. They
should never be seen by the user. They are not guaranteed to be
sequential nor to remain positive.

It's better to spend your development efforts on things that make a
difference.

HTH