I have 2 queries that come from a transactions table. One selects the additions and the other the deductions.
I am trying to create a 3rd query that will calculate the sum of additions, the sum of deductions and then calculate the difference to be my Qty on hand.
I had done this 3rd query before in Access 2003
Sum of Inventory Additions_Qty: Quantity
Sum of Inventory Deductions_Qty: Quantity
On Hand:[sum of Inventory Additions_Qty]-Nz([sumof Inventory Deductions_Qty],0)
Now that I am on Access 2010 Web Db, it is telling me the expressions are wrong…