change a first-last to last, first

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

_Bigred - 18 May 2005 04:07 GMT

Using Access 2000

I have a db with every single player that has ever played with the Milw.
Brewers.

But this table has the Player's Name

All in one field like such: John Doe (just a space between the first
& last name).

Is there a way to seperate this into two fields OR flip it and include a
comma
so it would either be
Last Name First Name
Doe John OR Doe,John

TIA,
_Bigred

Reply to this Message

Duane Hookom - 18 May 2005 06:53 GMT

Is the data always consistent? If so you can add two new fields and use an
update query which updates the new fields with expressions like:
Left([PlayerName], Instr([PlayerName]," ")-1)
and
Mid([PlayerName], Instr([PlayerName]," ")+1)
I would recommend against putting these back into one field. Store "Gorman"
and "Thomas" rather than "Thomas, Gorman".

Signature

Duane Hookom
MS Access MVP from WI

> Using Access 2000
>
[quoted text clipped - 14 lines]
> TIA,
> _Bigred

Reply to this Message

_Bigred - 18 May 2005 14:57 GMT

Thanks Duane, I will check this out and let you know if it fix my issue.

_Bigred

> Is the data always consistent? If so you can add two new fields and use an
> update query which updates the new fields with expressions like:
[quoted text clipped - 22 lines]
>> TIA,
>> _Bigred

Reply to this Message