更新查询以重新编号具有起始编号的列 [英] Update Query to Renumber a Column with a Starting Number
问题描述
我正在尝试找到一种简单的方法来使用序列号更新列而不使用记录集。这是捕获,每个机构都有一个范围,如阿纳海姆 - 6,000范围布埃纳公园 - 7,000范围...大多数记录已经编号但有一组不是和重新编号需要从另一组开始离开了。所以阿纳海姆将从6,292开始。我有29个不同的代理商,每个代理商都有不同的起始编号(我在一个单独的表中)。任何人都可以帮忙吗?
谢谢!
I''m trying to find a simple way to update a column with sequential numbers without using a recordset. Here is the catch, each agency has a range such as Anaheim - 6,000 range Buena Park - 7,000 range... most of the records have already been numbered but there is a set that is not and the renumbering needs to start where the other set left off. So the Anaheim would start at 6,292. I have 29 different agencies, each with a different starting number (which I have in a separate table). Can anyone help out??
Thanks!
推荐答案
可能。
你能用一些例子数据解释一下你实际想要实现的目标吗?
Possibly.
Can you explain, possibly using some example data, what it is you''re actually trying to achieve?
由于我不知道的原因,数据现在看起来像这样(虽然有每个机构的这么多记录......因此需要一些自动化)
代理商ID_NUM
ALISO VIEJO 9102 >
ALISO VIEJO 9104
ALISO VIEJO 9103
ALISO VIEJO 9107
ALISO VIEJO 9110
布埃纳PARK 9111
布纳纳公园9115
布纳公园9117
布纳公园9118
BREA 9119
BREA 9120
BREA 9122
我需要它更像这样:
AGENCY ID_NUM
ALISO VIEJO 8201
ALISO VIEJO 8202
ALISO VIEJO 8203
ALISO VIEJO 8204 >
ALISO VIEJO 8205
布纳纳公园6293
布埃纳公园6294
布纳纳公园6295
布埃纳公园6296
BREA 5445
BREA 5446
BREA 5447
For reasons unknown to me the data looks like this right now (although there are many more than this many records for each agency... hence the need for some automation)
AGENCY ID_NUM
ALISO VIEJO 9102
ALISO VIEJO 9104
ALISO VIEJO 9103
ALISO VIEJO 9107
ALISO VIEJO 9110
BUENA PARK 9111
BUENA PARK 9115
BUENA PARK 9117
BUENA PARK 9118
BREA 9119
BREA 9120
BREA 9122
I need it to be more like this:
AGENCY ID_NUM
ALISO VIEJO 8201
ALISO VIEJO 8202
ALISO VIEJO 8203
ALISO VIEJO 8204
ALISO VIEJO 8205
BUENA PARK 6293
BUENA PARK 6294
BUENA PARK 6295
BUENA PARK 6296
BREA 5445
BREA 5446
BREA 5447
这在一定程度上有所帮助。
>
您是否希望更新现有记录以使其与数据匹配,但是到位?在同一张桌子上?如果是这样,首先将数据准备到新的(如果是重复的)表中,然后在成功完成数据后将数据移回(并删除原始数据)可能更有意义。
That helps to a certain extent.
Are you wanting to update the existing records such that they match the data, but in place? In the same table? If so, it would probably make more sense to prepare the data into a new (if duplicate) table first, then move the data back (and delete the originals) when that has been successfully accomplished.
这篇关于更新查询以重新编号具有起始编号的列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!