Find Duplicate Values

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Is there an easy way to get a list of duplicate values in
a field? I am trying to set a key field in a table that
appearantly has some duplicate entries. I need to get a
report on the dupes.
Thanks in advance
 
Bruce,

One way is to create a totals query with your key field
brought in twice. The first instance set to Group By and the
second to Count.

Now you can create a new query containing your table related
to this totals query by the key field which will appear in
both.Now bring in the key field from the table along with
other fields that you need for comparisons and then bring in
the CountofKeyField or whatever it is from the totals query.
Set the criteria for this field to be > 1 and should just
give you a list of all the dups so you can decide how to
change which.

Of course, you could always use the FindDuplicates Query
Wizard if you want to save yourself some work. It does this
same thing basically <gr>.

Gary Miller
Sisters, OR
 
Bruce said:
Is there an easy way to get a list of duplicate values in
a field? I am trying to set a key field in a table that
appearantly has some duplicate entries. I need to get a
report on the dupes.
Thanks in advance
Click to expand...

There is a Duplicates Query Wizard which should be available every time you
start a new query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top