How do you reset an autonum to 0 after deleting all records in a tbl 1

[Goot]

I am testing a routine that has a table with an autonum field. I have entered about two dozen records via testing.
How do I reset the autonum to 0. If I remember, If I delete all the records, the next record will be whatever the internal counter is +1.

 

[PHV]

Compact and repair the database.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Goot]

WOW simple as that! Great thanks