I have a table where I want to indentify duplicates, for which I can create a query using the query wizard
which give me the following formula for the 'Manufactures Item No' field
In (SELECT [Manufactures Item No] FROM [A DairyCrest Master List] As Tmp GROUP BY [Manufactures Item No],[Manufacturer] HAVING Count(*)>1 And [Manufacturer] = [A DairyCrest Master List].[Manufacturer]) And <>'#'
What I would like to include where the 'New Description is not the same, but don't know what the query should be