Hi
Maybe this what you are looking for:
Code:
SELECT Tb_Inventory.PartName, Tb_Inventory.QC1, Tb_Inventory.QC2, Tb_Inventory.QC3, Tb_Inventory.QC4, Tb_Inventory.Side, Tb_Inventory.DK, Sum(Tb_OrderDetails.Quantity) AS SumOfQuantity
FROM Tb_Order RIGHT JOIN ((Tb_Inventory LEFT JOIN Tb_OrderDetails ON Tb_Inventory.MSHH = Tb_OrderDetails.MSHH) LEFT JOIN tb_Toa_Details ON Tb_Inventory.MSHH = tb_Toa_Details.MSHH) ON Tb_Order.OrderID = Tb_OrderDetails.OrderID
GROUP BY Tb_Inventory.PartName, Tb_Inventory.QC1, Tb_Inventory.QC2, Tb_Inventory.QC3, Tb_Inventory.QC4, Tb_Inventory.Side, Tb_Inventory.DK, Tb_Order.Status
HAVING (((Tb_Inventory.PartName)="bac nhat") AND ((Tb_Inventory.QC1)="3t") AND ((Tb_Order.Status)=True));