could someone please tell how i can reset an autonumber field to start from 1.

basically i have created a table and carried out a number of test with useless data. now that i have the table set up the way i want it and i have tested the queries etc i want to delete all the current data in the table and begin filling it with correct data. however i want my primary id to start from 1 which at the moment it doesn't because i have just deleted 50 records.

thanks in advance

Delete all the records, then compact and repair the database.

Thanks for that