We have Microsoft Access 2010 as a database for our closed files and have just gone from No. 9999 to 10000 (from 4 numbers to 5 numbers) and now instead of continuing on with numbering after 9999, Access has begun the numbers beginning with 10000 at the TOP of our database, so whenever we enter a new number, we now have to go to the very BOTTOM to enter that new number, but when we get out of Access and then get back in it, that new number (and all of the next new numbers) will be located at the TOP of Access, instead of continuing on at the BOTTOM like it always has. Is there any way at all to make Access continue the numbering at the BOTTOM of our Access list like it always has without having to go through and add a "0" before all of our numbers to make the existing numbers have 5 numbers? Thank you for anyone who might have an answer!
asked Sep 08 '14 at 13:01