By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

First name and last name

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
"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
Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.