I have a table that contains a field which I have manually set to Number, Fixed, 2 Decimal places (to try and resolve this problem) yet when I do the following query on it, some records that are sum'd produce a value that has 8 decimal places or more or a suffix (i.e. SumAmount
-7.27595761418343E-12). It would seem that one or more of certain records have an amount that has multiple decimal places (even though they don't appear to when simply viewing the table.
I need the amount in Table2 to be truly 2 decimal places as I need to compare this field value with another field in a different table and make a decision based on whether the values are equal or not.
SELECT Table1.Control, Sum(Table1.Amount) AS SumAmount INTO Table2
GROUP BY Table1.Control;