[RESOLVED] ACCESS DB SUM() not summing correctly

[Chrissy]

I have an Access 2003 Database. I am trying to SUM a field and in a couple of instances, it is returning a strange number.

For example, the database contains these numbers:

124.25
100.1
200.5

The sum should be 424.85 and it is returning something like 424.849999999998. I looked in the database and there are no strange numbers stored... they are all 2 decimal places. The following is the query I am using.

SELECT SUM(amount) as xAmt, month FROM detail where year = '2011' AND ocode = '23130' GROUP BY month

I attached the table with the query so you can see for yourself.

Any suggestions are greatly appreciated!