# 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

• Hi lmb,

Sorry, it works great.

Tim

Tim Reid

• Marked as answer by 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.

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 Friday, October 27, 2017 5:04 PM
Friday, October 27, 2017 5:04 PM