ok...
basically I am building a query using Access.
One of my fields has all the information, but in one full string (like the example I first posted in the topic).
I am trying to extract each string piece individually(ie.NAME, ADDRESS, CODE, etc.)
so, using the ACCESS Query Design builder...