Decimals

Question

I am working with some calculations and I need to convert a number like 12.28 to 12.2.  Everything I have tried has rounded the number to 12.3 which will not work for me.  Any suggestions?

---

Tim Reid

Answer 1

Write your own rounding function. Call it Floor, just like in Excel.

---

-Tom. Microsoft Access MVP

Answer 2

I need to convert a number like 12.28 to 12.2.

Hi TIm,

You can use:

  = Round(cur_value - 0.05,1)

Imb.

Answer 3

Hi lmb,

Thanks for the suggestion but I am dealing with calculations of which I do not know the initial result so if the number were 12.21 and I used you example it would give me 12.1 instead of 12.2 which would be incorrect.

---

Tim Reid

Answer 4

Thanks for the suggestion but I am dealing with calculations of which I do not know the initial result so if the number were 12.21 and I used you example it would give me 12.1 instead of 12.2 which would be incorrect.

Hi TIm,

You must have very special code. I get:   Round(12.21 - 0.05,1) = 12.2

Imb.

Answer 5

Hi lmb,

Sorry, it works great.

Tim

---

Tim Reid