<div>
=[FirstName] &amp;&nbsp;&quot; &quot;&nbsp;&amp; [LastName]<br />
<br />
Displays the values that reside in table fields called FirstName and LastName. In this example, the &amp;&nbsp;operator is used to combine the FirstName field, a space character (enclosed in quotation marks), and the LastName field.
</div>


=[FirstName] & " " & [LastName]

Displays the values that reside in table fields called FirstName and LastName. In this example, the & operator is used to combine the FirstName field, a space character (enclosed in quotation marks), and the LastName field.

<div>
Thank you ... this worked perfectly!<br />
<br />
Gary
</div>


Thank you ... this worked perfectly!

Gary

<div>
<div class="content wysiwyg-content">
I have a database, which is travel related and all names appear in one field &quot;PASSENGENAMEUPPER&quot; in the format ...<br />
<br />
SMITH/ANDREW MR<br />
JONES/BARBARA MRS<br />
KENT/CLARK WILLIAM MR<br />
<br />
I can extract the salutation correctly with:<br />
Salutation: Mid([PASSENGERNAMEUPPER],I<wbr />nStrRev([P<wbr />ASSENGERNA<wbr />MEUPPER],&quot;<wbr /> &quot;)+1)<br />
<br />
I can extract the last name correctly with:<br />
Last_Name: Left([PASSENGERNAMEUPPER],<wbr />InStr([PAS<wbr />SENGERNAME<wbr />UPPER],&quot;/&quot;<wbr />)-1)<br />
<br />
But I am stuck with trying to just get the first name and any corresponding second names .. keeping in mnd that some names might have just 1 first name and sime might have multiple. So basically I am looking to extract anything after the slash and before the salutation<br />
<br />
Any assistance would be greatly appreciated<br />
<br />
Thanks<br />
<br />
Gary
</div>
</div>


I have a database, which is travel related and all names appear in one field "PASSENGENAMEUPPER" in the format ...

SMITH/ANDREW MR
JONES/BARBARA MRS
KENT/CLARK WILLIAM MR

I can extract the salutation correctly with:
Salutation: Mid([PASSENGERNAMEUPPER],InStrRev([PASSENGERNAMEUPPER]," ")+1)

I can extract the last name correctly with:
Last_Name: Left([PASSENGERNAMEUPPER],InStr([PASSENGERNAMEUPPER],"/")-1)

But I am stuck with trying to just get the first name and any corresponding second names .. keeping in mnd that some names might have just 1 first name and sime might have multiple. So basically I am looking to extract anything after the slash and before the salutation

Any assistance would be greatly appreciated

Thanks

Gary

Need help in extracting specific components of a name in Access 2007

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.