HOw to parse multiple text data into seperate fields
I am analyzing survey data that I have imported into Access. One field has multiple text strings (up to six) separated by semi colons. I am looking for the easiest way to parse this field into multiple fields. Thanks for any insight.