-
I'm trying to use a calculated field (Net), the results being based on 3 other fields, namely Gross, Commission and Tax
I've added the following too my query: -
ROUND(([GrossPrice]+[Tax]-((([GrossPrice]+[Tax])/100)*[Commission])),2) AS Net
which works wonderfully, but for one thing...
the round part of the statement and the 2 at the end rounds (obviously) the result down to 2 decimal places, so i dont end up looking at spurious anounts of decimal places
what i want to do now is force Net to have 2 decimal places, so £123 would be £123.00. the problem is I haven't got a clue how to do this. do any of you clever bods out there know?
-
Try
Format(ROUND(([GrossPrice]+[Tax]-((([GrossPrice]+[Tax])/100)*[Commission])),2),"0.00") AS Net
