如何创建一个唯一的序列号。基于项目选择 [英] How to create a unique serial no. based on item selections
问题描述
如何创建唯一的序列号，即TR - F。用于家具或M对于杂项，或V，如果车辆从类别列表中选择并且后缀的4位序列号，则如下所示，TR-F-1004。
TR不会更改，仅基于所选类别的字母和4位自动编号字段，以创建用于标记库存项目的唯一标签。
在所附的例子中，55加仑桶被选中，所以
"标签号码"字段填充TR-55G1035 4位数字来自一个自动编号字段。
非常感谢你对此的帮助！
How do I create a unique serial number, i.e., TR - "F" for furniture or "M" for Misc, or "V" if Vehicle if selected from a list of categories and a 4-digit serial number for the suffix, to look like this, "TR-F-1004."
TR will not change, only the letter based on the category selected and a 4-digit autonumber field to create a unique label for labeling inventory items.
In the example attached, "55 gallon barrel" was selected, so the
"label number" field populated "TR-55G1035" the 4-digit number comes should come from a auto number field.
Would really appreciate your help on this!
推荐答案
pbsnow，
我是 位 感到困惑。您 想要 这个4位数字是否是自动编号？如果是这样，则无需计算序列号，因为记录本身将具有唯一标识符，您可以在运行时将该号码应用于序列号。
但是，如果不是这种情况，但实际上您需要为每种类型的项目提供唯一的序列号（例如：
pbsnow,
I am a bit confused. Do you want the 4 digit number to be an AutoNumber or not? If so, then there is no real need to calculate the serial number, as the record itself will have a unique identifier, and you can apply that number to your Serial Number during run time.
However, if this is not the case, but you actually want unique serial numbers for each type of item (e.g.:
这个主题在这里已被多次覆盖...
请在这个网站上搜索，
使用橙色旁边的框顶部的放大镜页面...输入搜索条件：
ms访问序列号
正常的建议是这样做在使用计算字段的查询中，而不是存储此信息：
Allen Browne：计算字段
计算字段MS ACC2003 虽然这是针对ACC2003的，但在较新版本中没有变化。
所以在您查询的情况下...
" TR-" &安培; [catagory_field]& [autonumber_field]
你可以用这个来获得更好的体验，并检查空值和其他条件;然而，这是基本的方法。
This topic has been covered many times here at bytes...
Please do a search on this site,
Use the box next to the orange magnifying-glass at the top of the page... enter the search terms:
ms access serial number
The normal advice is to do this in a query using a calculated field and not to store this information:
Allen Browne: Calculated Fields
Calculated Fields MS ACC2003 Although this is for ACC2003 this has not changed in the newer versions.
so in your case in the query...
"TR-" & [catagory_field] & [autonumber_field]
You can get fancier with this and check for null values and other conditions; however, this is the basic method.
@Z，
我认为它早在你所在的地方...... />
; - ）
@Z,
I think it''s earlier where you are....
;-)
这篇关于如何创建一个唯一的序列号。基于项目选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
