Rounding Down Decimals

S

Simon One

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
 
S

Simon One

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...
 
Top