Access Database De-Duping

[falconis]

I have moved an excel database into access. I would like to remove the duplicate numbers from this database: easy I know. ButI also need to capture these duplicates for a report.

 

[KenReay]

Hi

Courtesy of the Access Setect Duplicates Query wizard builder, SQL like the following will give you a query to pick out the duplicates:

SELECT DISTINCTROW EnquiryDetails.EnquiryId, EnquiryDetails.ItemNo, EnquiryDetails.strSupplierPartNo
FROM EnquiryDetails
WHERE (((EnquiryDetails.EnquiryId) In (SELECT [EnquiryId] FROM [EnquiryDetails] As Tmp GROUP BY [EnquiryId] HAVING Count(*)>1 )))
ORDER BY EnquiryDetails.EnquiryId;

Substitute your own table and clumn names, and then make a report based on this query

Regards
Ken Reay
Freelance Developer
kenneth.reay@talk21.com