I have the following MS Access query:
SELECT *
FROM (SELECT [cnPart],[desc] as DATA,"desc" as CAT from PartData
UNION SELECT [cnPart], [qty], "qty" FROM PartData
UNION SELECT [cnPart], [matl],"matl" FROM PartData
UNION SELECT [cnPart], [spec],"spec" FROM PartData) AS A
WHERE (((A.[cnPart]) In...