Concatenation and brackets

[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

 

[RoyVidar]

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

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

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