access 请帮忙啊, 急急急急急急......

我需要建立 UIN (Unique Identification Number), 它是由以下的字母和数字组成的.

1st digit: First letter of first name, if unavailable, enter ‘9’
2nd digit: Third letter of first name, if unavailable, enter ‘9’
3rd digit: First letter of last name, if unavailable, enter ‘9’
4th digit: Third letter of last name, if unavailable, enter ‘9’
5th & 6th digits: Month of birth (01 to 12)
7th & 8th digits: Day of birth (01 to 31)
9th & 10th digits: Year of birth (00 to 99), do not use century
11th digit: Gender (Male: 1, Female: 2, Transgender: 3, Unknown: 4)
12th digit: Race/Ethnicity (White/Non Hispanic: 1, Black or African American/Non Hispanic: 2, Hispanic/Latino(a): 3, Asian: 4, Native Hawaiian/Pacific Islander: 5, American Indian or Alaskan Native: 6, Two or more races: 7, Unknown/Unreported: 8

以上的数据都有了, 我只需要在现成table里用expression再创建一个UIN即可.请问这个 expression 该如何写.
谢谢大家了!

所有跟帖： 

• 作业？问错地方了。到国内编程论坛问吧 -flywhc- ♂ (0 bytes) () 02/23/2010 postreply 17:53:47

• Use Excel -zy3- ♂ (272 bytes) () 02/24/2010 postreply 11:37:52