I'm using Access 2000 on Windows XP. When I do a subtraction in a query such as 30,000-30,000 which should result to 0, I get the result 3.6379.......on and on. Does anyone have an idea what the problem could be???
Sounds like some formatting is hiding the full value of the figures you are subtracting, ie they may show as 30,000 but the exact value is slightly different. Where are the figures being derived from?
