Eliminate duplicate records

  • Thread starter Thread starter Dr. Brad
  • Start date Start date
D

Dr. Brad

Good evening,

I use Windows XP Pro and Access XP Pro (2003).

I have a table with some duplicate records. I want to create a query that
will select the records; however, I want only one copy of any duplicate
records selected.

How do I write this query??

Brad
 
Sun said:
I use Windows XP Pro and Access XP Pro (2003).

I have a table with some duplicate records. I want to create a query that
will select the records; however, I want only one copy of any duplicate
records selected.
Click to expand...

Under New Query there's "Find duplicates wizard". I'll bet by
inserting or removing a NOT in strategic place(s) you'll have what
you want.

But you're really better off to post this query to
microsoft.public.access.queries. I've crossposted this article, and
directed followups there only.
 
Dr. Brad said:
Good evening,

I use Windows XP Pro and Access XP Pro (2003).

I have a table with some duplicate records. I want to create a query that
will select the records; however, I want only one copy of any duplicate
records selected.

How do I write this query??

Brad
Click to expand...

It's a long time since I did anything in Access, but I seem to remember that
if you do a "Make Table" query, and you set the field that has the
duplicates as a Primary key. Then, when you run the query, it can only
create one entry for each duplicated record.

I "think" that's how it goes..... long long time ago......memory
fading.......

Rob Lepper
 
Thanks Rob,

Brad

OM said:
It's a long time since I did anything in Access, but I seem to remember
that if you do a "Make Table" query, and you set the field that has the
duplicates as a Primary key. Then, when you run the query, it can only
create one entry for each duplicated record.

I "think" that's how it goes..... long long time ago......memory
fading.......

Rob Lepper
Click to expand...
 
Back
Top