I have to parse names into three se

[kacie]

I have to parse names into three seperate fields: Lst Name, Fst Name, Middle. The company is sending me the name in one field ie : Smith, James E. or Smith, James

Using MS Access Update queries how can I parse the name out into the three fields?

Thanks.

 

[psemianonymous]

Several threads on the subject:

http://groups.google.com/groups?hl=...ms-access&meta=group=comp.databases.ms-access

It boils down to learning and using VBA's built-in InStr(), Left(), Mid(), Right(), and/or Len() functions in update queries.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm