<div>
<div class="content wysiwyg-content">
I have an access field with data such as :<br />
&nbsp; &lt;ROOT&gt;&lt;NEW_DATA FILE_NO=&quot;5535&quot; BRANCH=&quot;02&quot; CUST_ORD_NO=&quot;&quot; TAX_NO=&quot;ON FILE&quot; TYPE=&quot;O&quot; FREIGHT=&quot;0.00&quot; SALESMAN=&quot;S201&quot; .<br />
<br />
&nbsp;I need a query that puts the FREIGHT in a separate field.<br />
&nbsp;The text varies, but The FREIGHT value is always preceded by &quot;FREIGHT=&quot; but I don't know how many digits long it will be ?
</div>
</div>


I have an access field with data such as :
  <ROOT><NEW_DATA FILE_NO="5535" BRANCH="02" CUST_ORD_NO="" TAX_NO="ON FILE" TYPE="O" FREIGHT="0.00" SALESMAN="S201" .

 I need a query that puts the FREIGHT in a separate field.
 The text varies, but The FREIGHT value is always preceded by "FREIGHT=" but I don't know how many digits long it will be ?

pull value out of an access field into separate field

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.