<div>
I think this should do it but cannot test at the moment.<br />
<br />

<pre><code id="code-20-40669272-1">SELECT Mid(name, Instring(name, &quot;(&quot;) + 1, Instring(name, &quot;)&quot;) + 1)</code></pre>
<br />
You may be better to just get the name from the database and then extract the 3 character designation
</div>


I think this should do it but cannot test at the moment.



SELECT Mid(name, Instring(name, "(") + 1, Instring(name, ")") + 1)


You may be better to just get the name from the database and then extract the 3 character designation

<div>
this will handle more than 3 letters in the parentheses<br />
<br />
select Trim (Replace(Replace(Mid([Name<wbr />], InStr([Name], &quot;(&quot;)), &quot;(&quot;, &quot;&quot;), &quot;)&quot;, &quot;&quot;))<br />
from tablex
</div>


this will handle more than 3 letters in the parentheses

select Trim (Replace(Replace(Mid([Name], InStr([Name], "(")), "(", ""), ")", ""))
from tablex

<div>
And a second look at mine and realised it will not work, should have been <br />
<br />

<pre><code id="code-20-40669443-1">SELECT Mid(name, Instring(name, &quot;(&quot;) + 1, 3)</code></pre>
</div>


And a second look at mine and realised it will not work, should have been



SELECT Mid(name, Instring(name, "(") + 1, 3)

<div>
And the minimum code:<br />
<br />
NME: Left(Right([FieldName],4),<wbr />3)<br />
<br />
/gustav
</div>


And the minimum code:

NME: Left(Right([FieldName],4),3)

/gustav

<div>
thanks to all, but this was first and all I needed
</div>


thanks to all, but this was first and all I needed

<div>
<div class="content wysiwyg-content">
I have an imported table that has 1 data field ('name') with the following records<br />
American Stairs (AMS)<br />
CherryWood (CHW)<br />
DoRay Furnishings (DRN)<br />
<br />
In a query, I need to separate the 3 character designation out from between the parenthesis... how can I do that in a query please?<br />
<br />
The parenthesis always start 1 space after the name, and the designation is always three characters long (i.e. AMS, CHW)<br />
<br />
Thanks
</div>
</div>


I have an imported table that has 1 data field ('name') with the following records
American Stairs (AMS)
CherryWood (CHW)
DoRay Furnishings (DRN)

In a query, I need to separate the 3 character designation out from between the parenthesis... how can I do that in a query please?

The parenthesis always start 1 space after the name, and the designation is always three characters long (i.e. AMS, CHW)

Thanks

Help with a query to pull data from within a string

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.