<div>
Try replace(replace(yourField,<wbr /> chr(34)chr(34), chr34), chr(34)chr(34), chr(34))
</div>


Try replace(replace(yourField, chr(34)chr(34), chr34), chr(34)chr(34), chr(34))

<div>
Try replace(replace(yourField,<wbr /> 'chr(34)chr(34)', 'chr34'), 'chr(34)chr(34)', 'chr(34)')
</div>


Try replace(replace(yourField, 'chr(34)chr(34)', 'chr34'), 'chr(34)chr(34)', 'chr(34)')

<div>
jerryb30,<br />
<br />
I think you are missing some concatenation operators :)<br />
<br />
Patrick
</div>


jerryb30,

I think you are missing some concatenation operators :)

Patrick

<div>
jjxia2001,<br />
<br />
Did you try either of mine?<br />
<br />
Patrick
</div>


jjxia2001,

Did you try either of mine?

Patrick

<div>
All three ways worked, but I like the one from buttersk. &nbsp;Thanks all!
</div>


All three ways worked, but I like the one from buttersk.  Thanks all!

<div>
<div class="content wysiwyg-content">
I have a field in an Access table to show three quotes such as this: &quot;&quot;&quot;0-2,500&quot;&quot;&quot;. I want to change it to &quot;0-2,500&quot;. &nbsp;How do I delete the extra &quot;. &nbsp;The length in the middle is not same, may have &quot;&quot;&quot;2,500-5,000&quot;&quot;&quot; or &quot;&quot;&quot;5,000-10,000&quot;&quot;&quot;.<br />
<br />
I tried MID function, but need the length: MID(fieldName,3,length), length is varied.<br />
<br />
Please help
</div>
</div>


I have a field in an Access table to show three quotes such as this: """0-2,500""". I want to change it to "0-2,500".  How do I delete the extra ".  The length in the middle is not same, may have """2,500-5,000""" or """5,000-10,000""".

I tried MID function, but need the length: MID(fieldName,3,length), length is varied.

Please help

Need help to format text field in ACCESS data table

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.