How to combine text from 3 columns?

[Natalie]

I would like to combine 3 columns into one. The columns are First Name
[FirstNm], Last Name [LastNm] and Date of Birth [DOB]. I need the first 2
letters of the first name, the first 3 letters of the last name and the month
and day of date of birth. I started using the Left Function.
Left([FirstNm],2) but I don't know how to continue.

 

[Rick B]

Where are you doing this? I will assume in a query.

NewField: Left([FirstNm],2) & Left([LastNm],3) & Format([DOB],"MMDD")

 

[xRoachx]

Hi Natalie, are you trying to create a 4th column or only display this? As a
recommendation, I would only display it. Try this:

Left([FirstNm], 2]) & Left([LastNm], 3) & Format([DOB],"mm\/dd")