In an Access query in design mode, I need a simple way to split a string. It will have more than three values.
Let's say my field Apple = "Hello,my,name,is,joel"
I want to do this:
Field A: Split ([Apple], "," 4)
The result should be "is".
Thanks for your help,