I have a table with three fields.
Product, Part Number and Quantity.
I have created a form to select two products by using combo boxes. comb1 and combo2 The query then needs to shows parts that are unique to each product selected above.
This sql brings up both sets of parts but I cannot achieve parts that are unique. Despite trying various ways to expand on this code, any pointers would be much appreciated.
TIA
Cliff
Product, Part Number and Quantity.
I have created a form to select two products by using combo boxes. comb1 and combo2 The query then needs to shows parts that are unique to each product selected above.
Code:
SELECT [Location Table].[Product Number], [Location Table].[Part Number], [Location Table].Qty
FROM [Location Table]
WHERE ((([Location Table].[Product Number])=[forms]![CSSimultaneousPanels]![combo1])) OR ((([Location Table].[Product Number])=[forms]![CSSimultaneousPanels]![combo2]))
ORDER BY [Location Table].[Part Number];
This sql brings up both sets of parts but I cannot achieve parts that are unique. Despite trying various ways to expand on this code, any pointers would be much appreciated.
TIA
Cliff