Conditional Unstored Sums?

[Cassetti]

See attached file for an example of what the situation is.

We have a job list for our company that keeps track of orders for customers and orders for testing equipment comming in.

We have a field called "Total Sold"

This is a sum of the Child database job items.

Problem is, the sum is not stored, it is auto calculated on demand. The Thing is, I want to know how i can set up "Total Sold"

To calculate only the quantity of the companies who are NOT "Inventory Test"

Please help someone, our numbers are way out of wack. (We have items that we just got in, and we tested 300 of them , and only sold 5 so far, but our total sold is 305, it should only be 5 because the 300 extra came from the testing database)

When you look at the inventory table - you will see the total sold on the 4 test items.

X1111 Total Sold Should be 4

X2222 Total Sold Should be 1

X3333 Total Sold Should be 2

X4444 Total Sold Should be 5

Sum_Calculation_Problem.zip