Splitting a concatenated name

[popeye]

someone asked me to work on an interface for some tables that they have already created and populated in access.

thing is one of the tables they have has a field called name which has names stored in it.

Both surname and firstname are stored in the SAAAMMMEEEE field. in the format "surname,firstname."


question. can access "magically" split these into two fields. one for surname and one for firstname.

I dont think its possible but im very willing to be wrong. IS there any magical code that can do this.

The database has 2817 records!!!!!!!!!

PLEASE DONT LET ME DO THIS THE OLD KEYBOARD STYLE.

 

[Rich]

Are first name and surname separated by a comma?

 

[popeye]

Yes they are,


ive seen some of your replies leo.

ru onto something/


they are written for example.. Bush, George

 

[Rich]

http://support.microsoft.com/default.aspx?kbid=95608

 

[popeye]

ACCESS IS THE GREATEST "that ive seen"

I WILL SEEK leo"the one" and thanks for the link you sent. So much for me thinking that i had to type the whole thing all over again.


you did save me a whole lot of time. Now i can focus on some real programming


By the way,

Whats with the expression "seek and ye shall find except in A2k and above"

the A2k and above part is killing me, particularly because A2k and A2k3 are what im using.... designing a system in A2k3 for computers that are running A2k....

id love 2 hear the reply./

 

[ecniv]

Instr
Mid

And a creative SQL statement (or two...)

Seek? Wassat?


Vince

 

[popeye]

Seek: Finding Information

when i say seek i mean i will continue my "Quest" for the source of knowledge from which you Senior programmers seem to be "Access"ing all your knowledge