Update query

  • Thread starter Thread starter mate
  • Start date Start date
M

mate

I run a query to show duplicate records that exist within
the table.
Results of query for example:

City St. Zip ID #ofDuplicates
anytown NY 12345 345 3

The problem is that it only shows one of the duplicate
records than tells how many dups there are. is there a
way for the query to show all 3 of the duplicate records
in the results? any help is greatly appreciated as
always. thanks and have a great day, mate.
 
You can create a new query, link your duplicates query to
the original table. That should give you all the rows in
the table that match the keys in your duplicates query.
 
will that still work even each record has a unique ID
number? I have duplicate records but no duplicate ID#'s
as its my prim.
 
Okay, I'm a little confused since your "results of query"
showed an ID# on it, which meant there were 3 rows with
that same data.

If ID shouldn't have been in your results, are you just
looking for duplicates on city, state and zip? Seems like
it's possible to have alot of dups on that.

But I think my idea will still work. Whatever fields you
used to find the dups will be the fields that you use to
join your query to your table.
 
Back
Top