Hello all,
I am trying to calculate a "Units on Hand" field from a query and haven't had any luch, I am not sure what I am missing or doing incorrectly. In the attached file, if you run the "Assembly Parts List with Build Qty from WO Table" query and enter the WO of "test" you'll get the results which are correct. I have tried to add a field at the end for "Qty on Hand" and haven't been able to get it. I would like to pull the info from the "Transaction Table" by adding the "UnitsReceived"-"UnitsSold"-UnitsShrikage". I have tried several times and I can't get the value to show.
Can someone please assist.
Dave -In Process.zip
Thanks
Dave