I have a table in Microsoft Access that collects survey results.
All the contents of the survay are collected in one column in the same cell one below each other.
I need to split the results into separate columns.
Each result could have multiple character length.
Number five could have up to 256 characters.
I know there is a function called (InStr).
Example of the data that shows up in one column below.
Could you please give me an example for this query argument.
5, Test Msg