Rounding

[BLD21]

access 2007,

I am having a rounding problem. I have a field that is set for [Total1] - [Total2]. Example $16.93 - $12.74 should = $4.19. However, it seems to be rounding up to $4.20. Is there any way to prevent this? I tried using the Round function but it didn't help.

Thanks!


Bruce D.

[RuralGuy]

What DataType are your fields? Where are you doing the calculation? On a form, in a query?

[BLD21]

The datatype fields are set for currency, 2 decimal places. The calculation is performed in a report using a unbound text field. I do have the option of using in a query as this is the source for the report as well. I've read something about "Bankers Rounding". I am wondering if I should change the data types from currency to something else or would I have to create a function?

[RuralGuy]

Any chance you could post your db?

[BLD21]

Thanks RG but I have it figured out. It seems one of my excel import files had one of the fields formatted to a general number. I changed it to currency and reimported. My calcuation looks fine now with the rounding function.

BD.

[RuralGuy]

Excellent! Thanks for posting back with your success.