How to restart and autonumber field

[samuvk]

I have a autonumber field, but it is always sum number even I delete all the records before.

I would like to konw if after delete all the records, there is any way to restart the autonumber field to zero.

Thanks

 

[pbaldy]

See if running a compact/repair after deleting the records resets the number for you.

 

[samuvk]

Did works.

Thanks Paul

 

[pbaldy]

No problem, glad it worked for you.