Sum Function doing strange things.

[Lloyd1313]

I'm running an Access 2000 app. In a query I'm using a sum function on a number defined as single. The sum function is not returning the correct total for the numbers, it's adding in decimal places that don't exist in the orginal numbers. The numbers have a max of 4 decimal places and the number returned has 9.

I changed the query one column gouping on the number and one column using a sum. The column using sum added on the additional decimal places but the goup by number remained consistant.

I'm running with service pack 3.

Thanks for any ideas you may have.

Lloyd.