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…

Is there a way to get Qty on hand for my styles?