I know you do have a point. It stems from my need to tidy. But I should
leave it alone.
Jen

"tina" wrote in message
...
the Autonumber should be used to provide a primary key for a table, and
for
nothing else. and it should never have meaning in the "real" world, or
ever
be seen by the user, whether in its' own table or in any table in which
it's
used as a foreign key. given the above, what's the reason you're concerned
about the values assigned by the Autonumber?

hth


"JB" somehow@somewhere wrote in message
...
Hello
when I appended some data into my main table, the autonumber jumped from
around 544 to 26300.
There are only 276 rows in the table.
The most rows I've deleted from the table would be maybe 200, when I was
designing and testing the table, certainly not 25000.

All I could find in Help was "Change the starting value of an AutoNumber
field". I followed the instructions but that didn't work.

Any suggestions on what I can do to lower the Autonumber?
The table is related to 2 other tables.

Thank you
Jen