<div>
CStr to convert to string in Access.<br />
OM Gang
</div>


CStr to convert to string in Access.
OM Gang

<div>
try this <br />
<br />
<br />
=&quot;1/&quot; &amp;&nbsp;formatNumber([tblLetterOfC<wbr />redit].[Am<wbr />ount]/[tbl<wbr />fees.Amoun<wbr />t]/100,2) &amp;&nbsp;&quot; of 1%&quot;<br />
<br />
<br />
or<br />
<br />
=&quot;1/&quot; &amp;&nbsp;formatNumber([tblLetterOfC<wbr />redit].[Am<wbr />ount]/[tbl<wbr />fees.Amoun<wbr />t]/100,1) &amp;&nbsp;&quot; of 1%&quot;<br />

</div>


try this


="1/" & formatNumber([tblLetterOfCredit].[Amount]/[tblfees.Amount]/100,2) & " of 1%"


or

="1/" & formatNumber([tblLetterOfCredit].[Amount]/[tblfees.Amount]/100,1) & " of 1%"


<div>
they both worked... &nbsp;thank you
</div>


<div>
but the reason I had the #Name was due to the my incorrect bracketing...
</div>


but the reason I had the #Name was due to the my incorrect bracketing...

<div>
looks like you picked one, that also have incorrect bracketing.<br />
<br />

</div>


looks like you picked one, that also have incorrect bracketing.



<div>
<div class="content wysiwyg-content">
Experts, <br />
<br />
I have a formula in Excel that works:<br />
<br />
=&quot;1/&quot;&amp;TEXT(B2/B3/100,0)&amp;&quot; of 1%&quot;<br />
and I converted it to a unbound text box as follows but I dont belive the TEXT function is applicable in Access? I get a #name:<br />
=&quot;1/&quot; &amp;&nbsp;Text([[tblLetterOfCredit].<wbr />[Amount]/[<wbr />tblfees.Am<wbr />ount]/100,<wbr />0) &amp;&nbsp;&quot; of 1%&quot;<br />
<br />
Any suggestions? &nbsp;
</div>
</div>


Experts, 

I have a formula in Excel that works:

="1/"&TEXT(B2/B3/100,0)&" of 1%"
and I converted it to a unbound text box as follows but I dont belive the TEXT function is applicable in Access? I get a #name:
="1/" & Text([[tblLetterOfCredit].[Amount]/[tblfees.Amount]/100,0) & " of 1%"

Any suggestions?  

Formula used in Excel

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.