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 wrote:
> 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)"

--
Roy-Vidar