Expression/Formula Help

[TomN]

I have a multi-column table. Three of the columns are Last Name, First Name
and Date of Birth (mm/dd/yyyy). I'd like to create another column as a
unique identifier based on these three. The fourth column would be first
three of last name, first three of first name, then date of birth
(LLLFFFMMDDYY).

So John Smith with date of birth 11/24/1970 would be SMIJOH112470. Any idea
how I could do that? I'm a novice and am learning as I go.

I know that there may be times when the first or last name are less than
three letters. So "Al Vu" with DOB 12/25/55, would be VUAL122555.

A huge thanks to anyone that replies.

 

[pietlinden]

I have a multi-column table.  Three of the columns are Last Name, FirstName
and Date of Birth (mm/dd/yyyy).  I'd like to create another column as a
unique identifier based on these three.  The fourth column would be first
three of last name, first three of first name, then date of birth
(LLLFFFMMDDYY).

So John Smith with date of birth 11/24/1970 would be SMIJOH112470.  Anyidea
how I could do that?  I'm a novice and am learning as I go.  

I know that there may be times when the first or last name are less than
three letters.  So "Al Vu" with DOB 12/25/55, would be VUAL122555.

A huge thanks to anyone that replies.

Total waste of time. Set the combination of the 3 fields to be
unique. "Smart" keys are not terribly smart. Nor do the guarantee
uniqueness. Just index those 3 fields and you should be fine.