Recent content by monika_V

What I'm trying to do is extremely simple. All I need, is to remove rows where are duplicates in the DATA column. So in the results I get, I need to remove the marked rows as these are the ones which contain duplicate data S1 and a4b7c3d4 |---------------------------| |cnPart |DATA...

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