<div>
you can use the Left(), Mid() function to extract part of the field<br />
<br />
this will give all info after the first space<br />
<br />
mid([fieldname], instr([FieldName],&quot; &quot;) +1)<br />
<br />
sample<br />
the quick brown fox<br />
<br />
will return<br />
quick brown fox<br />
<br />
using the mid() function posted above
</div>


you can use the Left(), Mid() function to extract part of the field

this will give all info after the first space

mid([fieldname], instr([FieldName]," ") +1)

sample
the quick brown fox

will return
quick brown fox

using the mid() function posted above

<div>
Here is what I have, I am having a hard time getting that to work:<br />
<br />
The field contains: 9:20 15:22 313/555-5555 P<br />
<br />
I need to extract the 15:22 (which is a call duration) for all of my accounts. The 9:20 time may be 10:50 and have an extra character at times, which is why I asked about the (space).<br />
<br />
I am getting a sytax error: (comma) in query expression. Below is my build line of logic:<br />
<br />
CallLength: (mid([PREVWeekPAPERLESS], instr[PAPERLESS_CMT1],&quot; &quot;)+1)
</div>


Here is what I have, I am having a hard time getting that to work:

The field contains: 9:20 15:22 313/555-5555 P

I need to extract the 15:22 (which is a call duration) for all of my accounts. The 9:20 time may be 10:50 and have an extra character at times, which is why I asked about the (space).

I am getting a sytax error: (comma) in query expression. Below is my build line of logic:

CallLength: (mid([PREVWeekPAPERLESS], instr[PAPERLESS_CMT1]," ")+1)

<div>
Worked, thank you! &nbsp;Just so I understand the code, what does the +1 and ,5 represent?
</div>


Worked, thank you!  Just so I understand the code, what does the +1 and ,5 represent?

<div>
+1, to select the character after the space<br />
5 the length of the string you want to get
</div>


+1, to select the character after the space
5 the length of the string you want to get

<div>
Thanks again, have a great day.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a long paperless not field and only need certain parts of it is there a way to pull only characters 10-15 say. Or maybe after the first (space)? &nbsp;Thank you.
</div>
</div>


Hello,

I have a long paperless not field and only need certain parts of it is there a way to pull only characters 10-15 say. Or maybe after the first (space)?  Thank you.

Only export parts of a field in ACCESS

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.