Dropping the decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What function do I use to drop the decimal places. I am using Access 97.

10/3=3.33333

I want to end up with 3 not 3.333333.
 
Use INT or FIX. They are similar for positive numbers, but behave a bit
differently on negative numbers.

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.
 
If you get 3.7 as a resault, which value would you like returned?

If also 3, then you can use int , but if you want 4 then use the Round

Round(10/3) = 3
Round(10/2.7) = 4
 
Back
Top