Divide in Access Query Won't display results less than 1
Posted on 2004-08-16
I have been trying to get an expression to work in an Access query. I thought i was writing my code wrongly until i decided to try a simple sum instead...
SELECT 2 / 10 AS [Sum]
This equals 0 according to access. If I change it to :
SELECT 2 * 10 AS [Sum]
This equals 20, as you would expect.
Why won't access divide numbers where the total is less than zero??