Stuck on a Calculation Multiplied by Another Column

[ahackett90]

I am attempting the practice exam for an exam I am sitting this Thursday and I am stuck on one of the queries:

• Calculate the total value of the missing stock. To do this, you must multiply the missing stock from question 5 by the Cost per Item column. Rename the calculated column appropriately. Include the Department ID number, Person in Charge and the calculated column. Sort in descending order. Save this query as VALUE OF MISSING STOCK.

I have calculated the total missing stock (from question 5 per the above) by subtracting the stock take count from the recorded stock on hand, which is fine, but I am having troubles multiplying this by the cost per item.

My query as it stands is as follows:




The calculation is: Missing Stock at Cost: [Stocktake Quantity]-[Recorded Quantity on Hand ]*[Cost per item]
Is this like excel where I need to have a second set of brackets around the subtraction before I can multiply?

I believe there is something wrong with my calculation to get the cost of the missing stock, but I am not sure what.
Please help! Thank you.

[Bob Fitz]

Perhaps:
(([Stocktake Quantity]-[Recorded Quantity on Hand]) * [Cost per item])

[orange]

Further to Bob's response, this is not an Excel vs Access thing. This is the precedence/order of operations in arithmetic expressions. Often referred to as BEDMAS which stands for
-brackets
-exponents
-division
-multiplication
-addition
-subtraction

The default order is left to right.

[ahackett90]

Thanks Bob! This is exactly what I was missing. I had tried using the {} brackets, but they are clearly not the correct ones.