请帮助设置特殊会员ID !!! [英] Pls Help for setting the special Member ID !!!

问题描述

我是使用Access 2007的新手。我准备了国家武术俱乐部的数据。会员ID的结构如下：


1.前两位数字是

俱乐部名称的首字母（例如Apple Club - 01 ，男孩俱乐部 - 02，

C - 03，D - 04 ......等）


2.接下来的3位数是俱乐部的号码

（例如Apple Club - 001，Aaron Club - 002，Alan

Club - 003 ....等等）


3.最后3位数是会员的数字

（例如Crystal Mui - 001，Quinton Kung - 002，

Armanda Rhee - 003 ......等）


所以，如果我想输入Armanda Rhee的会员ID并且她在Apple Club，她是第一个进入系统的会员...会员ID是01-001 -003


所以，有任何想法???请帮助ppppp！

Thkssssss。

Hi, I am new babies to use Access 2007. I am prepared the data for the National Martial Art Club. The structure for the Member ID is as follow:

1. The first 2 digits are the first letter of the
Club Name (e.g. Apple Club - 01, Boy Club - 02,
C - 03, D - 04 ... etc)

2. The next 3 digits are the number of the club
(e.g. Apple Club - 001, Aaron Club - 002, Alan
Club - 003 .... etc)

3. The last 3 digits are the number for the Members
(e.g. Crystal Mui - 001, Quinton Kung - 002,
Armanda Rhee - 003 ... etc)

So, if I want enter the Member ID for Armanda Rhee and she is in Apple Club and she is the first one member enter in the system ... the Member ID is 01-001-003

So, have any idea ??? Pls help ppppp!

Thkssssss.

推荐答案

你实际上并没有问过一个问题。告诉我们你在做什么是困难，然后我们可以帮助你。谢谢。


Pat

You haven''t actually asked a question. Tell us what it is you are having trouble doing and then maybe we can help you. Thanks.

Pat

任何人（或计算机）如何知道Apple Club与01号相关联？这些信息可从哪里获得？


您从问题中留下了许多重要信息。如果你甚至不提问题，很难提供帮助。

How would anyone (or the computer) know that Apple Club is associated with the number 01? Where is this information made available from?

You leave a lot of important information out of your question. It''s hard to help if you don''t even provide a question.

@NeoPa


对不起，我很抱歉。


我想输入数据中的所有althetics信息，包括他们的竞争结果。因为我们将在八月举办武术比赛。获胜者将代表安大略省与9月份的其他省份竞争。


因此，我使用Access Student模板进行基本设置，但俱乐部决定分配会员ID遵循上述规则的每个理论。这意味着他们按照俱乐部名称的第一个字母，然后哪个俱乐部首先登记为01，第二个是02 ......第三个是03 ......等等。最后一组是为了althetics。


我试图为第一封信创建一个表格：


ID第一个字母数字

1 A 01

2 B 02

3 C 03

4 D 04

...直到Z＃26

$ b $那么，我的表名是俱乐部。和字段名称俱乐部ID。当我为新俱乐部输入新记录时，我希望Access 2007将自动通用俱乐部ID＃。


例如


俱乐部会员ID俱乐部名称地址

01-001 Apple Club 123 abc st

01-002 Aaron Club 456 def st

02-001 Bay Club 78 Howard st

02-002 Brick Club 90 College St

02-003 Block club 90 King St
...等


如果我有Advance Club的新记录，Access 2007会自动将ID＃发布为01-003。在记录中。如何设置俱乐部ID字段中的代码？


我很抱歉我的英语。我希望所有专家都能理解。


非常感谢你。

@NeoPa
I am sorry for my posting not clearly.

I want to enter all the althetics information in the data including their competition results. It is because we will have the Wushu competition event in August. The winner will be represent Ontario to compete with the other provincial in Sept.

So, I use Access Students template for the basic set-up, but the club decided to assign the member ID to every althetics following the above rules. That means they followed their 1st letter of the club name, then which clubs register first is 01, second is 02 ... third is 03 ... etc. The last group is for the althetics.

I tried to create a table for 1st Letter :

ID 1st Letter Number
1 A 01
2 B 02
3 C 03
4 D 04
... until Z #26

then, I have the table name "Clubs" and field name "Clubs ID". When I enter new record for the new club, I want the Access 2007 will auto generic the Club ID #.

e.g.

Club ID Club Name Address
01-001 Apple Club 123 abc st
01-002 Aaron Club 456 def st
02-001 Bay Club 78 Howard st
02-002 Brick Club 90 College St
02-003 Block club 90 King St
... etc

If I have new record for "Advance Club", the Access 2007 will auto post the ID # as "01-003" in the record. How to set the code in the Club ID field?

I am so sorry for my english. I hope all the experts can understand.

Thank you so much.

这篇关于请帮助设置特殊会员ID !!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！