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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!