Extracting the first name

[John]

Hi

How can I extract the first name from the full name where each name is
separated by spaces?

Thanks

Regards

[fredg]

On Sat, 11 Nov 2006 18:46:41 -0000, John wrote:

Hi

How can I extract the first name from the full name where each name is
separated by spaces?

Thanks

Regards

The full name is stored exactly as FirstName LastName
i.e. "John Smith"?

FirstName:Left([FullName],InStr([FullName]," ")-1)
LastName:Mid([FullName],InStr([FullName]," ") +1)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Larry Linson]

"John" <Jo**@nospam.infovis.co.ukwrote

How can I extract the first name from the
full name where each name is
separated by spaces?

If all the names are "well-formed," that is trivial, as fredg has explained.

On the other hand, if your names are like the names most of us find, the
problem is a little more complicated.

First names like "Ella May", or "Joe Ed", or "J' Ann", or "De Anne" -- which
may look to you like "first and middle" are often truly "first names" and if
you use it to modify text or address a letter to "Dear Ella" or "Dear Joe",
it may not exactly the opposite of the effect for which you hoped.

Carefully review the names in question and post back here.

Larry Linson
Microsoft Access MVP