Trim Digits after decimal point

[brendalanigan]

Hello,

I have been asked to trim a number field in an Access database to remove all but the first two digits after the decimal point. The number of digits before the decimal point varies and I have am having some difficulty creating a script that will ignore the digits before the point and just trim those after.

If anyone has any suggestions I will be most grateful.

 

[Remou]

You can use both Round and Format, but be aware that they give different results:

[tt]?Round(12.985,2)
12.98

?Format(12.985,"#.00")
12.99[/tt]

 

[lameid]

For positive numbers anyway: Take number times 100. Round down to the nearest integer and divide by 100...

INT(<VALUE> * 100)/100

For positive and negative...

IIF(<Value> < 0,-1,1) * INT(ABS(<VALUE>) * 100)/100

 

[PHV]

You may try this:
Fix([decimal field]*100)/100

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886