How to combine text from 3 columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Where are you doing this? I will assume in a query.

NewField: Left([FirstNm],2) & Left([LastNm],3) & Format([DOB],"MMDD")
 
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")
 
Back
Top