Concatenation question

  • Thread starter Thread starter Terri
  • Start date Start date
T

Terri

I am trying to concatenate two fields and then add text in brackets to the
end. Here is what I have:

StaffFullName = ([Me.LastName] & ", " & [Me.FirstName] & " (Mgr)")

I want the end result to be: Smith, Mary (Mgr)

How do I achieve this?

Thank you,
Terri
 
What you've done will work. You can also use the "+" operator if there is a
possibility that there will be a missing first name:

StaffFullName = ([Me.LastName] & "," & (" "+ [Me.FirstName]) & " (Mgr)")

That will avoid an extra space if the first name is missing.
 
Back
Top