Dropping the decimal places

[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.

 

[John Spencer]

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.

 

[Guest]

Use the Interger division operator.
Where 10/3=3.33333
10\3 = 3

 

[Guest]

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