访问2016 AutoNumber [英] Access 2016 AutoNumber
问题描述
免责声明：我不是Access的专家，我没有建立数据库，它已经存在了近10年，我正在学习如何使用它来完成我的工作。到目前为止，我对数据库没有任何经验。
Disclaimer: I'm no expert with Access and I did not build the database, it's been around for the past 10 years and I'm learning to use it with my job. I've had no experience with databases until now.
我有一个查询和一条路线停靠表。数字列和停止名称的列。现在一切都是手动完成的。我遇到的问题是，当我需要在路线上添加一个新的停靠点时，我必须坐在这里并手动重新编号
所有内容，所以当列表打印出来时它会保持有序。
I have a Query and a table of stops along a route. Column of numbers and a column of the name of the stop. As it is now everything is done manually. The problem I have is when I need to add a new stop on the route I have to sit here and manually renumber everything so when the list gets printed out it stays in order.
所以在路线上说：1,2,3,4,5,6,7,8,9 ......我需要在7到8之间进行新的停止。我必须输入1,2， 3,4,5,6,7,8,9,10。除了我有大约200站的事实之外，做其他事情并不困难。有没有办法在某个地方的
列表中添加一个数字点，它可以自动调整数字？自动编号是否以这种方式工作？我查了一下自动编号，但似乎只是添加到列表的底部，我需要在整个列表中添加。
So say on the route: 1,2,3,4,5,6,7,8,9... I need to a new stop in between 7 and 8. I have to type in 1,2,3,4,5,6,7,8,9,10. It's not a hard thing to do other than the fact that I have about 200 stops. Is there a way to add a number point in the list somewhere and it can auto adjust the numbers? Does auto number work in this way? I've looked up auto number but it seems to only add to the bottom of the list, I need to add throughout the list.
感谢！
推荐答案
您好，
您不能将Autonumbers用于此目的。一旦使用了自动编号，就无法重复使用。
You can't use Autonumbers for this purpose. Once an Autonumber is used, it can't be reused.
您可以使用代码或其他方法执行此操作。例如，请查看此演示以重新排列排序顺序表中的记录。
You can do this using code or some other approach. For example, take a look at this demo for rearranging the sort order of records in a table.
希望它有所帮助......
Hope it helps a little...
这篇关于访问2016 AutoNumber的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
