生成唯一的序列号 [英] generate a unique serial number

问题描述

我需要为表格中的每个字段生成唯一的序列号。序列号应包含两个字母和六个数字，例如AA123456。有人可以建议如何在MS Access中执行此操作

I need to generate a unique serial number for each field in the table. The serial number shall consist of two letters and six numbers, for example AA123456. Someone can suggest how to do it in MS Access

推荐答案

您能提供更多信息吗？你说表中的每个字段是正确的还是你的意思是每行/记录？是否有特定原因必须以两个字母和6个数字的描述格式提供它？只是好奇，因为这听起来很奇怪。我看到你有很多观点，零回复。如果有更多信息可以帮助您更好地了解您要完成的任务，那可能会更好。保重&上帝保佑〜斯蒂芬

Can you provide any more information? You say each field in the table is that correct or did you mean each row / record? Is there a specific reason you have to have it in the described format of "two letters and 6 numbers"? Just curious as that sounds very strange. I see you have a lot of views with zero replies. It may be better if there was more information to work with to better understand what you are trying to accomplish. Take Care & God Bless ~ Stephen

谢谢斯蒂芬！有关于汽车及其所有者和其他一些文件的信息表，所有这些信息都将写在特殊清单上（一辆汽车及其所有者一行），我需要一个唯一的序列号，表格中的每一行。两个字母和6个数字是本文档的标准。有效的是字母和数字的单独生成器，在不同的字段中。我希望有人会帮助我;）

Thanks Stephen! There is table with information about cars and its owners and some other documents, all this information will be writen on the special list (one row for one car and its owner), I need a unique serial number for each row in the table. Two letters and 6 numbers is a standart for this documents. Valid is a separate generator for letters and numbers, in diferent fields. I hope someone will help me ;)

还有一个问题：当你说有效是一个单独的字母和数字生成器，在不同的字段中时你是说这个值必须在两个单独的字段中，或者它可以在两个单独的字段中？

One more question: When you say "Valid is a seperate generator for letters and numbers, in different fields" are you saying that the value has to be in two seperate fields or that it can be in two seperate fields?

这篇关于生成唯一的序列号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！