Hi How can I reset the number in a autonumber field thanks
T tom Nov 3, 2003 #3 Delete all records and compact the database, then reinsert data if necessary. Tom.