Author: TotallyConfused Date: Jun 26, 2008 23:41
Thank you very much for your response. However, this works fine when there
is a MidNM or Initial and period. But when there is no MidNM, then it leaves
2 spaces instead of just one space between first Name and last name. Can
this be fixed? if so how? Thank you.
> On Thu, 26 Jun 2008 12:51:37 -0700, TotallyConfused wrote:
>> How do I write a query that say the following: If there is a middle name,
>> then Middle Name and space. If there is not a middle name, then no space. I
>> am trying to concactenate First, Middle and Last Names. But do not want a
>> double space if there is no middle name. Any help will be great appreciated
>> Thank you.
> CominedNames:[First Name] & (" "+[MiddleName]) & " " & [LastName]
> Please respond only to this newsgroup.
> I do not reply to personal e-mail