Query Rounding

[RayMilhon]

I have a query in MS Access 2010. I have a field where I need to divide 2 Numbers. The result I need is the whole number but I don't want it to round so even if the result is 215.99999 I want the field to display 215. I tried the Fixed format but that rounds it doesn't truncate. Excel has a Truncate Function but as far as I know Access does not. Any ideas?

[JoeM]

Use the INT function, which drops the decimal and just returns the integer portion of a number, i.e.

INT([Number1]/[Number2])

[RayMilhon]

Ok that's what I was doing Wrong I was using CINT not INT. Thanks.