Rounding Dilema

DS · Mar 12, 2007

I have a rounding problem.

If I divide 15 by 2 I get .075 but I need to store it in a table as .08 How
would I do this?

Thanks
DS

AccessVandal via AccessMonster.com · Mar 12, 2007

Hi DS,

Try

yourControlName = Round(0.15 / 2, 3)

DS wrote:
I have a rounding problem.

If I divide 15 by 2 I get .075 but I need to store it in a table as .08 How
would I do this?

Thanks
DS

DS · Mar 13, 2007

That worked! Thanks DS

AccessVandal via AccessMonster.com said:
Hi DS,

Try

yourControlName = Round(0.15 / 2, 3)