Remove duplicate records

[Jen Scott]

If I want to create a table from a query and not add any of the records that
have duplicates, how do I do that? If there are 2 records that are the same,
I don't want to add either record to the new table. Thanks!

 

[Jerry Whittle]

Some table and field name would help us to help you.

Does the table have a primary key field?

By duplicate, do you mean every field in the record is exactly the same or
just some of the field?

If every record is exactly the same, you'll need to do a Totals query and
Group By all the fields. Then you'll need to add a field, it really doesn't
matter which as long as every record as data in it, and do a Count of that
field instead of a Group By. In the criteria for that field, make it 1. That
will give you all the unique records. Then convert that query to an Append
query.

 

[Al Campagna]

Jen,
It's very doubtful that you could clean out all the dupe records in
one make-table query.
Unless... you have an "iron clad" or "never fail" logic as to what
constitutes a
"duplicate" record, it will be more a matter hand editing to find all the
dupes.
Example: Any records with the same phone number will be deleted.

How are you determining that records are duplicate?
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."