Calculated Field

[Jimbob]

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?

[MartinLiss]

Try

Format(ROUND(([GrossPrice]+[Tax]-((([GrossPrice]+[Tax])/100)*[Commission])),2),"0.00") AS Net