none
Decimals RRS feed

  • 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

    Friday, October 27, 2017 12:32 AM

Answers

All replies

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

    -Tom. Microsoft Access MVP

    Friday, October 27, 2017 3:09 AM
  • I need to convert a number like 12.28 to 12.2.

    Hi TIm,

    You can use:

      = Round(cur_value - 0.05,1)

    Imb.

    Friday, October 27, 2017 5:56 AM
  • 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

    Friday, October 27, 2017 3:12 PM
  • 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.

    Friday, October 27, 2017 4:13 PM
  • Hi lmb,

    Sorry, it works great.

    Tim


    Tim Reid

    • Marked as answer by Tim Reid Friday, October 27, 2017 5:04 PM
    Friday, October 27, 2017 5:04 PM