wrote in
:

I currently have a table that has data in it. I would
like to add an auto number field.

Create a new empty table with all the fields in it plus the new autonumber
column. Append the old table into it.


Every time I add the
field, make the datatype auto number the numbering will
not start at 1.

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


HTH


Tim F