First name and last name

[Edmund Wong]

I have one client fiield that stores First and last name. I would like
to separate the names into a lastname field and firstname field. Can
anyone tell me how to do this?

thanks

[fredg]

On Mon, 24 May 2004 19:29:36 GMT, Edmund Wong wrote:

I have one client fiield that stores First and last name. I would like
to separate the names into a lastname field and firstname field. Can
anyone tell me how to do this?

thanks

If all the records have the data stored as
FirstName LastName (a space between the names)
you can use:
[FirstName] = Left([FullName],InStr([FullName]," ")-1)
[LastName] = Mid([FullName],InStr([FullName]," ")+1)
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Dave Brydon]

"Edmund Wong" <ed********@sboglobal.net> wrote in message
news:q5********************************@4ax.com...

I have one client fiield that stores First and last name. I would like
to separate the names into a lastname field and firstname field. Can
anyone tell me how to do this?

thanks

Edmund,

Create a new query, and add your table, which has your clients name in it.
Drag the clients "Full Name" field into the first query design grid, then
you must create two new expressions, example:

FirstName: Left([FullName],Instr([FullName]," ")-1)

LastName: Mid([FullName],Instr([FullName]," ")+1)

Enusre to change "FullName" to the name of your field.

HTHs,

Cheers,

Dave

[Mark G. King]

Edmund,

There's a DLL which splits names called NameParser. It works with any VB or
VBA application.
Check it out at:
http://www.infoplan.com.au/nameparser

- Mark
"Edmund Wong" <ed********@sboglobal.net> wrote in message
news:q5********************************@4ax.com...

I have one client fiield that stores First and last name. I would like
to separate the names into a lastname field and firstname field. Can
anyone tell me how to do this?

thanks