I have the code below in my query design view, When the query runs, the results go to 5 or 6 decimal places.
How to i format to a fixed decimal place of 2 ?
How to i format to a fixed decimal place of 2 ?
Code:
Tax_Amount: IIf((Len([Customer_Itentity])<7),[Charge_Amount]/100*20,"0.00")