I am having trouble with a query which uses the results of sub queries for it's data.
I have included an extract below:
SELECT DISTINCT qryItemNumber.item, IIf(NZ([qryComposition2].[DESCRIPTOR_VALUE])<>"","FOUND","NOT FOUND") AS Expr1
FROM qryComposition2, qryItemNumber;
What should...