Query total returns much higher value than expect in Access 2010
Posted on 2014-10-28
I have a simple query that correctly returns three records as shown below when no Group By is used. It simply lists each record separately.
Amt NbrAffordableUnitsCreated NbrJobsCreated
When I add a Group By to sum the Amt, NbrAffordableUnitsCreated, and NbrJobsCreated columns the Amt appears as $1,444,638,537 instead of $1,144,636 while the other two colums sum correctly. Something is causing the Amt to increase roughly a 1,000 times more than it should. A copy of the query and output is attached (you may need to enlarge to read it).
Any suggestions on why this is happening would be greatly appreciated.