Duplicates

[Gianmaria I.]

Hi,
i'm tring to set a column as primary key but the operations is impossible
cause i have duplicates in this column.. how can i search and delete this
duplicates?

Regards

 

[George Nicholson]

Queries>New: Find Duplicates Query Wizard
(Assuming you have a full installation...)

or:

The following would list the Description and AssetIDs for all records with
duplicate Descriptions in table datAsset:
SELECT Description, AssetID
FROM datAssets
WHERE (((Description) In (SELECT [Description]
FROM [datAssets] As Tmp
GROUP BY [Description] HAVING Count(*)>1 )))
ORDER BY Description;

HTH,