Third time lucky!
The append query has no results!
I'm just starting to look at all the underlying queries used in your append query
First of all recommend you avoid spaces in table, query & field names
The query "Relieve Inventory ....BKP" has 78894 records but it uses what is called a cartesian join AKA no join between tables
Rearranging the tables in the query design window shows 2 unrelated groups of 3 tables so you get every possible combination of results from each
Joining both tblPartMain by the PK field reduces this to 4 records.
The same outcome can be got with this simplified code
Code:
SELECT tblPartMain.MfrPartNumber, tblPartMain.PartDescription, tblPartMain.PartMainID_PK, tblPartMain.MfrPartNumber AS Child_PN, tblPartMain.PartDescription AS Child_Description, [tblOptimumPurchasedParts 10-15-18].PurchasedPart, [Work Orders].Qty, [tblOptimumPurchasedParts 10-15-18]![Qty]*[Work Orders]![Qty] AS [Build Qty], [Work Orders].DHRNumber, [Work Orders].DHRID, [Work Orders].SerialNum, [Inventory Transactions].ProductID, [tblOptimumPurchasedParts 10-15-18].QtyFROM (tblCategories INNER JOIN ((tblPartMain INNER JOIN [Inventory Transactions] ON tblPartMain.PartMainID_PK = [Inventory Transactions].ProductID) INNER JOIN [Work Orders] ON ([Work Orders].DHRID = [Inventory Transactions].DHRID) AND (tblPartMain.PartMainID_PK = [Work Orders].PartID)) ON tblCategories.ID = tblPartMain.CategoryID) INNER JOIN [tblOptimumPurchasedParts 10-15-18] ON tblPartMain.PartMainID_PK = [tblOptimumPurchasedParts 10-15-18].ChildID
WHERE ((([tblOptimumPurchasedParts 10-15-18].PurchasedPart)=True));
In the designer that looks like
Can you see the next issue?
To get results, both ProductID & DHRID have to be identical. Can you see why?
And is that really what you want?
Check the above is what you want & after I hear back from you, I'll carry on ...
Two more issues:
Qty is shown twice but are the same value - remove one of them from the design
You are using captions for the field DHRNumber (Work Order #) & DHRID (Work Order ID) which makes it unnecessarily difficult to follow what's happening