I’m very new to Access and I’m wondering if anyone can help me figure out how to use the result of a SUM in another field to perform a calculation on it.
For example, I have a table of pre-built computers and their cost, and another table with hardware components that were used and their cost. I’ve calculated the sum of the hardware components to build said computer, so now I have a column that has the price of the computer and a column that has the sum of all used components. Now I want to use some sort of computer price minus sum of components expression to get the difference to display in another column.
I hope that makes sense. I would really appreciate any help. Thanks!