<div>
Use a combination of Mid and Instr.<br />
<br />
What have you tried so far?
</div>


Use a combination of Mid and Instr.

What have you tried so far?

<div>
Right([tblPaper.Descriptio<wbr />n],InStr([<wbr />tblPaper.D<wbr />escription<wbr />],&quot;-&quot;)-2)<br />
<br />
But it isn't even close.
</div>


Right([tblPaper.Description],InStr([tblPaper.Description],"-")-2)

But it isn't even close.

<div>
<div class="content wysiwyg-content">
If I have a string of characters that looks like this:<br />
<br />
#10 Small - something - something else<br />
<br />
And I want to extract in query designer this part of it: (everything to the right of the 1st hyphen not including the space in front of the 1st &quot;something&quot;)<br />
<br />
something - something else<br />
<br />
How can I do this?
</div>
</div>


If I have a string of characters that looks like this:

#10 Small - something - something else

And I want to extract in query designer this part of it: (everything to the right of the 1st hyphen not including the space in front of the 1st "something")

something - something else

How can I do this?

How extract string of characters to the right of the 1st hyphen

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.