Find Duplicates

[Guest]

Hi,

I have a table that has 15 columns and 30,000 rows.
I want to find the rows with duplicate values in column #1.

Is there a way to extract these rows?

Thanks for your help.

 

[Jeff Boyce]

From the database window, click on the <New> toolbar button dropdown, select
query.

From the list, pick the 'duplicates' query wizard. It will walk you through
the process and create the query for you.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[CarolK]

Once I have this query, is there a way to go back and delete these duplicate
records from the query?

Carol