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

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
GHnatAsked:
Who is Participating?
 
IrogSintaConnect With a Mentor Commented:
You could try:

First_Name:Mid([PASSENGERNAMEUPPER],InStr([PASSENGERNAMEUPPER],"/")+1,InStrRev([PASSENGERNAMEUPPER]," ")-InStr([PASSENGERNAMEUPPER],"/")-1)
0
 
mrfixit22Commented:
=[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.
0
 
GHnatAuthor Commented:
Thank you ... this worked perfectly!

Gary
0
All Courses

From novice to tech pro — start learning today.