Autonumbering gone wrong Microsoft Access
Home > IT Answers > Database > Autonumbering gone wrong Microsoft Access
Kball
5 pts.
0
Q:
Autonumbering gone wrong Microsoft Access
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?
ASKED: Jul 3 2008  7:32 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
BigKat
2540 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 - Affiliated
Last Answered: Jul 8 2008  5:37 PM GMT by BigKat   2540 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0