I have this Query
This is Query Q1
How do I put it into the first one, to make a single Query def?
Thank you
Code:
SELECT Materials.MaterialID, Materials.MaterialName, MaterialType_Table.MaterialTypeName
FROM (MaterialType_Table INNER JOIN Materials ON MaterialType_Table.MaterialTypeID = Materials.MaterialTypeID) LEFT JOIN Q1 ON Materials.MaterialID = Q1.MaterialID
WHERE Q1.MaterialID) Is Null
This is Query Q1
How do I put it into the first one, to make a single Query def?
Code:
SELECT Products_Materials.MaterialID
FROM Products_Materials
WHERE Products_Materials.ProductID=[Forms]![Products_Form]![ProductID]
Thank you