PC Review


Reply
Thread Tools Rate Thread

Concatenation and brackets

 
 
Terri
Guest
Posts: n/a
 
      19th Dec 2009
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

 
Reply With Quote
 
 
 
 
RoyVidar
Guest
Posts: n/a
 
      19th Dec 2009
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


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
when are [ ] brackets used cmat Microsoft Excel Worksheet Functions 2 21st Oct 2008 10:35 PM
help with brackets =?Utf-8?B?dG9tYnJhZHNoYXd1aw==?= Microsoft Excel Misc 3 17th Nov 2006 10:19 PM
Using Brackets in SQL =?Utf-8?B?RnJlZCBIZXJyaW5n?= Microsoft ADO .NET 5 15th Dec 2004 07:06 PM
add neg # using brackets =?Utf-8?B?a2Vu?= Microsoft Excel Setup 1 23rd Sep 2004 06:23 PM
brackets Mike Microsoft ASP .NET 0 27th Apr 2004 07:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:22 AM.