MS Access: Some Results = -1 or 1, when 0 is expected
Running a query in MS Access and a few of the SUM results that should = 0 are coming out -1 and 1. The data types in the table it references are Double with 6 Decimal places. When I take the same numbers out of MS Access and add them in Excel the result is 0. Any suggestions would be great! Thanks!