you can reset the autonumber by compacting the database. Then it will resume numbering after the highest value in the table.
Peter --- In [email protected], "workkball" <[EMAIL PROTECTED]> wrote: > > I have created an append query w/o the autonumbering field because I > want the added data to continue the number of the table I am adding > this information to. The query works except it does not autonumber > from the last number in the table. It is jumping about 30,000 numbers > and then begins consecutive numbering. Anyone have any idea what I am > doing wrong? >
