"Brian C" wrote in
:


How can I reset this value so that the record when added
is given the value 1.



You can reset an empty table by compacting and repairing the database. If
there are records in it, though, then you can't (and wouldn't want to) go
back over used numbers.

Remember the Autonumber Commandment: "If you care what value an Autonumber
has, then you probably should not be using an Autonumber"

B Wishes


Tim F