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?
- [ms_access] Autonumbering problem with append query. workkball
