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?