truncate function

[yyyoong]

If i have a number and i try to use this expression to truncate the number (with 2 decimal places)in the query, but it doesn't work, can anyone please help me ?

TRUNC(number, 2)

 

[pdx_man]

Have you looked up the TRUNC function in Access Help?

Is this a function you wrote? Should look like this:

Public Function TruncIt(Value, Optional Precision As Variant) As Double

    If IsNull(Value) Then Exit Function
    If IsMissing(Precision) Then Precision = 2
    Value = Fix(Value * 10 ^ Precision * Sgn(Value)) / 10 ^ Precision
    TruncIt= Value
    
End Function