currency fields rounded numbers

[DeanRowe]

Hi,

All my fields are currency fields and they are set to 2 decimal places, both in the table and the form that uses it.

On my form I multiply Field A by Field B and the result shows in Field C.

The answer in Field C appears to be a 2 decimal figure but when I click on the field it shows 3 decimal places.

For Example:

£160.85 (Field A) x £.70 (Field B) = £112.60 (Field C)
but when I click on Field C it shows £112.595.

When I copy this field, or use it in another calculation it uses the £112.595 figure rather than the £112.60 figure. I'm dealing with Tax sums so it's quite important that I get it spot on, is there any way I can get the figure to "lock" to 2 decimal places so when I use field C for another calculation it uses the 2 decimal answer rather than the 3 decimal answer?

Should I change over from a currency field to something else?

Also, this has only just come to my attention after already performing thousands of calculations based on Field C - is there any way, after I've fixed the above problem, that I can update the data in Field C that I've already done so its only 2 decimal places (that way I can go back and redo each calculation thats based on the figure in Field C).

Thank you for your time.

Dean

 

[ajetrumpet]

If you have used a query for your calculated fields, you could insert the ROUND function in your query for Field C to take care of the problem.

 

[DeanRowe]

I calculated C directly on the form using:

Me.FieldC.Value = [FieldA] * [FieldB]

Thanks for responding ajetrumpet