Partial text returned from a query

S

Ste

Joined
Nov 20, 2017
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Command button to look up and copy data from a query to a table 0
Search a second table from a form 2
Access Access IIF and Instr function 6
With F1 value, look at A, if match or partial match return B 5
Text Box to display 4
Need help rewriting a macro 1
Access Access 2007 Delete Part of Text 0
Query returning partial result set 1

Top