Is there a way to split a field with Full names (ex:John A. Doe) into First, Middle, and Last name fields? I have seen plug-in shareware to perform the task, but is there a way to do it within Access itself?
You'd have to write code to parse the field at spaces. It's tiresome when you do, because names are rarely uniform - I have three forenames, fo instance.
If you don't want to write code, you canexprot the fireld to Excel, which has a parsing routine built in, but you still have the problem of non-uniformity.
Finally, I think that Woody's Access Watch might have addressed the issue. Try searching the internet for Helen Feddema, who would have written the article.
Access makes all things possible. It even makes them intelligible
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.