Copying Autonumbers and preserving autonums

[Kerropiday]

Hi,

Would like to know if it is possible to copy autonumbers
from one field directly into another autonumer field
however preserving the numbers? I am trying to recreate a
particular table but I am stumped when it comes to copying
over these autonumbers because in the recreated table
Access doesn't "preserve" them. This field must be an
autonumber field..... I am beginning to think it is not
possible?

 

[Sal Rosario]

An Append query should do the job for you.

Sal
www.cedrostec.com