Çë´ó¼Ò°ï°ïæ access ÎÊÌâ, Thank you very much!

ÎÒÓÐÒ»¸ö¶ÀÁ¢µÄ table, called patient infor, it has: first name, last name, DOB, gender and race.
ÏÖÔÚÎÒÈçºÎ create a field named UIN using expression follow by UIN formula below.

The UIN is a 12 digit number consisting of both letters and numbers. The UIN is created using the following formula: 
 
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
 

---

  ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
  ²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html
   
  1. ÄãµÄ create table xxx .. Óï¾ä
  2. ÄãµÄ insert