Rounding numbers in a calculated field 1

[Tash]

Hi,

What type of formula could I use in a control source of a field to round/truncate numbers?

Thank you!

 

[tlbroadbent]

Use the Round() function to round. Use the Int or Fix function to truncate. Access Help explains the difference between Int and Fix.

Both Int and Fix remove the fractional part of number and return the resulting integer value.

The difference between Int and Fix is that if number is negative, Int returns the first negative integer less than or equal to number, whereas Fix returns the first negative integer greater than or equal to number. For example, Int converts -8.4 to -9, and Fix converts -8.4 to -8.

Fix(number) is equivalent to:

Sgn(number) * Int(Abs(number))



Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Tash]

THANK YOU!!! That just saved me a BIG headache on my database. I appreciate the help, I used the "Fix" and it worked perfectly.