Rounding Down Decimals

[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

 

[Van T. Dinh]

Int([YourNumber] * 100) / 100.0

 

[Guest]

Superb, thank you

Int([YourNumber] * 100) / 100.0

--
HTH
Van T. Dinh
MVP (Access)

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

 

[Van T. Dinh]

You're welcome ... Glad to help ...