Formula used in Excel

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?  
pdvsaProject financeAsked:
Who is Participating?
 
GRayLCommented:
Try:

="1/" & Round([[tblLetterOfCredit].[Amount]/[tblfees.Amount]/100,0) & " of 1%"
0
 
omgangIT ManagerCommented:
CStr to convert to string in Access.
OM Gang
0
 
Rey Obrero (Capricorn1)Commented:
try this


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


or

="1/" & formatNumber([tblLetterOfCredit].[Amount]/[tblfees.Amount]/100,1) & " of 1%"
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
pdvsaProject financeAuthor Commented:
they both worked...  thank you
0
 
pdvsaProject financeAuthor Commented:
but the reason I had the #Name was due to the my incorrect bracketing...
0
 
Rey Obrero (Capricorn1)Commented:
looks like you picked one, that also have incorrect bracketing.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.