Search results

Hi, I'm new to Access (using office 365) and so far it's all going well but I'm a bit stuck. I'm trying to split (in a select qry) part of a text string (which is a file path) eg: Field "Path" eg D:\Music\CD Collection\2000\Rock\ what I'm trying to achieve is, irrespective of the number of...