I have the following sample of data.
Name - state - office - numbers.
I want to just return everything after the second hyphen. The office and the numbers. I can't quite get this query to work. What am I doing wrong?
Right([JobName],InStr([JobName],"-")+1)
also-they are all variable in length
Name - state - office - numbers.
I want to just return everything after the second hyphen. The office and the numbers. I can't quite get this query to work. What am I doing wrong?
Right([JobName],InStr([JobName],"-")+1)
also-they are all variable in length