Rounding Down Decimals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2K

I need to round down the results of calculation decimals to 2 decimal places
IE:

3.899 round down to 3.89
2.6167128 round down to 2.61

Any help gratefully recieved

Regards

Simon
 
Superb, thank you

Van T. Dinh said:
Int([YourNumber] * 100) / 100.0

--
HTH
Van T. Dinh
MVP (Access)



Simon One said:
Access 2K

I need to round down the results of calculation decimals to 2 decimal
places
IE:

3.899 round down to 3.89
2.6167128 round down to 2.61

Any help gratefully recieved

Regards

Simon
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Always Round Down 2
Rounding number 15
Rounding expression in a query 1
Pivot Table rounding 3
Excel Stop Excel from displaying rounded values 4
Rounding Question 3
Rounding up of decimal values 4
Access stripping decimal places in query 1

Back
Top