Concatenation and brackets

  • 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. I am sure the issue lies with the brackets. 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
 
Terri said:
I am trying to concatenate two fields and then add text in brackets
to the end. I am sure the issue lies with the brackets. 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
Click to expand...

If the rest is correct, just remove them, the brackets, that is:

StaffFullName = Me.LastName & ", " & Me.FirstName & " (Mgr)"
 
Back
Top