SQL for Access

[keenanloo]

I have a fairly large table which may or may not have duplicate records. My job is filter out a destroy them......

So I'm try to find the duplicate fields only, if any exist, and delete them. I'm having mucho trouble with this. Can someone give me a SQL statement that will allow me to do this?

Thanks

[antares686]

There are many ways to do. But first what determines if is a duplicate?

[keenanloo]

It's a database that hold account information such as phone numbers, addresses, and such. So duplicates will be of an entire row.

So I'm looking for the ability to seek out all exactly duplicated records.

But also, it would be nice to search for duplicated fields.

Basically anything you can give me would be great.

Thanks.

[kimmckenzie]

Access has a query wizard for duplicates. Use that and make sure to check out the SQL behind the query after you build it.:D