Autonumbering gone wrong Microsoft Access
I am using an append query to add data to a table. The query works except I have an autonumbering field and am not including it in my query because I want to continue the autonumbering in the table I am adding data to. The only problem is, is that the autonumbering is beginning from a much higher number. Why is it not adding number continuously?
Software/Hardware used:
Software/Hardware used:
ASKED:
July 3, 2008 7:32 PM
UPDATED:
July 8, 2008 5:37 PM
Answer Wiki:
The autonumber field increments every time a record is added. If you delete records and re-add them, there will be a gap where the original records were numbered.
Kevin C. Ketzler - <a href="http://www.aresgrp.com">Affiliated</a>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
