Well I will have to make some assumptions so let's see if this helps.<br>I assume 3 tables:<br><br>Table Fields<br><br>Orders- OrdID, ProductID, Qty<br>SubParts- ProductID, SubPartID, QtyNeeded<br>PartInven- SubPartID, PartName, QtyonHand<br><br>Create a query on all 3 tables and show the PartName field and a calculated field called TotalParts with the expression: [qty]*[qtyNeeded]<br><br>Create a second query that uses this query and the PartInven table and create a calculated field called Balance that uses this expression: Balance: [QtyonHand]-[totalparts].<br><br>That will show your balance. <br><br>Of course you can throw in whatever other tables/fields you need to see and if you really need to you can make some Append or Make table queries to throw the info into another table.<br><br>I hope some of these ideas give you a starting point for completing your project.<br>