If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change the starting value of an AutoNumber field
Hello
when I appended some data into my main table, the autonumber jumped from around 544 to 26300. There are only 276 rows in the table. The most rows I've deleted from the table would be maybe 200, when I was designing and testing the table, certainly not 25000. All I could find in Help was "Change the starting value of an AutoNumber field". I followed the instructions but that didn't work. Any suggestions on what I can do to lower the Autonumber? The table is related to 2 other tables. Thank you Jen |
Thread Tools | |
Display Modes | |
|
|