Dear AccessBlaster,
I don't have an old table to start with, we have some records that need to continue the ID number from the past. How do I do. Also don't know how to create a append query. Please help!!!
but you do not want to try and use an autonumber like that. there is no guarantee of an intact sequence with an autonumber. if you need an intact sequence then you need a different approach.