I have a query that i am using in VB against Access. The query sums the following number in a table:
The result is 0.0177 but when I run the query in access I get this number: 0.01769999996759. I realized that I can format the number but I do not understand WHY the query does not return just 0.0177. The field is single type and I have tried double but have gotten the same result. Is there anyway to get this to return the correct result everytime without have to format it and could someone please explain why I get this number with extended decimal places?