Search results

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...