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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Terri" <(E-Mail Removed)> wrote in message
news:5A9BB51E-24E8-40A3-941F-(E-Mail Removed)...
>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