Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Trying to format as currency with 4 decimals on a report

I m betting a result like this on a report:

1 per yard

Using this:
=[BuyerTraderCommission] & " per" & " " & DLookUp("[Description]","tblUnitOfMeasuresLU","[UofMID] = " & [Forms]![frmDealInput]![cboUnitOfMeasureID])

But I want it to display like:

$1.0000 per yard.  ( 4 decimals)

Or if the result was :

.0254 per yard

I want the field to look like:

$0.0254 per yard

How can I do this?
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial