Goal / Problem
What I am trying to do is fairly simple. I have two fields,
. In the table, there may be multiple transactions for each invoice. So I'm simply trying to sum all transactions for each invoice number so I'll have one transaction sum for each invoice number (which I can later subtract from a balance to get the remaining balance). Sounds simple, and typically is... but I'm having an issue (or bug? that DOES NOT result in an error)!
Here is a query that will give a snippet of my data:
SELECT [_MasterLog_Transactions].InvoiceNbr, [_MasterLog_Transactions].TransAmt
GROUP BY [_MasterLog_Transactions].InvoiceNbr, [_MasterLog_Transactions].TransAmt
This results in:
If I add a 'totals' row using the Access GUI, and choose "SUM", it correctly calculates "$4,764.98". And for other random reference, in the
is a 'number' field, field size 'double', and format 'currency' -- so it should be capable of being used with the SUM function.
So working from the above data, I created the query:
Sum([_MasterLog_Transactions].TransAmt) AS MyTest
GROUP BY [_MasterLog_Transactions].InvoiceNbr
My Query Results
I would have expected:
No errors occur. It runs and Access seems to think it is outputting the proper result.
Am I overlooking something really simple here, or is this an Access bug I've never run into? Any help would be greatly appreciated! Thanks.