<div>
where are the numbers located <br />
<br />
if the numbers are located in front &nbsp;12345abj<br />
<br />
val(&quot;12345abj&quot;) &nbsp;will give you &nbsp;12345<br />
<br />
<br />
if anywhere else , you will need a function
</div>


where are the numbers located

if the numbers are located in front  12345abj

val("12345abj")  will give you  12345


if anywhere else , you will need a function

<div>
also you can use the functions &nbsp;left,mid, right and instr, instrrev depending on the format of the string
</div>


also you can use the functions  left,mid, right and instr, instrrev depending on the format of the string

<div>
Super quick response.<br />
For clarificaion:<br />
The [Reference] data in each field is generally &quot;12345&quot;, but the ones I need to extract are &quot;10155, 10211, 10255&quot; and ignore the records with text in the record. <br />
<br />
I'm just going to try out your function.<br />
<br />
Cheers<br />
<br />

</div>


Super quick response.
For clarificaion:
The [Reference] data in each field is generally "12345", but the ones I need to extract are "10155, 10211, 10255" and ignore the records with text in the record.

I'm just going to try out your function.

Cheers



<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
Need a bit of quick help.<br />
I have a &nbsp;table with [ID], [Date], [ClientID],[reference]<br />
<br />
Some of the records have a series of numbers in the [reference] field &nbsp;eg. 10215, 10555, 10331 <br />
<br />
I'm want to make a query to create a new table with these numbers extracted with their own record each, but I need help of on the extraction part :)<br />
<br />
Thanks in advance<br />

</div>
</div>


Hi Experts,

Need a bit of quick help.
I have a  table with [ID], [Date], [ClientID],[reference]

Some of the records have a series of numbers in the [reference] field  eg. 10215, 10555, 10331 

I'm want to make a query to create a new table with these numbers extracted with their own record each, but I need help of on the extraction part :)

Thanks in advance


Query to extract numbers from text 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.