I have a dataset with a number of duplicate values. I want to select records where the values in fields NAME, Year, Type, Levels, Values are exactly the same. Once this is verified I need to delete the duplicates keeping one record.
I've tried the find duplicates query wizard and I don't think I have the correct result. See below code block, is it correct?
SELECT BaseTable.[NAMES] AS [NAMES Field], BaseTable.[Year] AS [Year Field], BaseTable.[Type] AS [Type Field], BaseTable.[Levels] AS [Levels Field], BaseTable.[Values] AS [Values Field], BaseTable.[NAMES] AS NumberOfDups
WHERE (((BaseTable.[NAMES])>1) And ((BaseTable.Values)>1));