evo 2 primjera:
1: Round(1.456, 2) 'ovo vraca vrijednost 1.46. Broj 2 je broj decimala
2: drugi primjer je modul koji mozes kopirati u svoju bazu i pozvati sa roundcurr
Public Function RoundCurr(OriginalValue As Currency, Optional
NumberOfDecimals As Integer) As Currency
On Error GoTo Error_Handler
'returns a currency value rounded to the specified number of decimals of
the Original Value
If IsMissing(NumberOfDecimals) Then
NumberOfDecimals = 0
End If
RoundCurr = Int((OriginalValue * (10 ^ NumberOfDecimals)) + 0.5) _
/ (10 ^ NumberOfDecimals)
Exit_Procedure:
Exit Function
Error_Handler:
MsgBox Err.Number & ", " & Err.Description
Resume Exit_Procedure
End Function
----There is no place like 127.0.0.1-----
Registrovani: 8 ( misamilanovic, vjova, Shadowed, palamar, zeoN_Rider, Horbi, bojanum, bachi )
Zaokruzivanje broja