Answered by:
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
Friday, October 27, 2017 12:32 AM
Answers

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
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.
 Proposed as answer by Deepak Saradkumar PanchalMicrosoft contingent staff Friday, October 27, 2017 7:29 AM
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