Seperate Names?

[Ielamrani]

Hi,
i have a name like this:

Smith John

I would like to seperate smith from John. In other words put Smith in one field and John in another field. There is a space between smith and John.

Thanks

Ismail

 

[THWatson]

Ismail
In a query create two new columns.

One, to isolate the first name, will have the following expression...
Left([MyName],InStr([MyName]," ")-1)

The other, to isolated the last name will have the following expression...
Mid([MyName],InStr([MyName]," ")+1)

Tom

 

[THWatson]

Ismail
Sorry, I should have indicated to change [MyName] to whatever your field, that contains the names, is called.

Tom

 

[Ielamrani]

thank you soooo much. I did change MyName to my field name.

Ismail