I apologize, I am unsure of where to put these functions? In Design View, will these go into the "SQL" section? I typically have input the data into the "Field" section of the actual query when it came to separating names in the past. But nothing this complex.
I need to un-concatenate for a query in Access. I need to separate a first name, last name and badge number. I don't need "Driver" in this anywhere. Just the name and badge number. Here are some examples of my information:
Driver: WALKER III, IRVIN W. (422103)
Driver: CASTRO COREA, JACKSON...
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.