finding Duplicates

  • Thread starter Thread starter Query on description
  • Start date Start date
Q

Query on description

I am trying to create a query where I look for duplicate records in a table.
I am trying to find duplicate OEM numbers with the same OEM manufacturer so
that will mean I need to create a query where looks at both columns. Please
help
 
The duplicates query wizard will build the query for you.

Click New in the database window when you are on queries tab
Select Find Duplicates Query Wizard and follow the instructions.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
I try to use the wizard but there is one filed that is in the table but it
doesnt show up in the wizard is there a way around that?
 
Nope. You will have to build the duplicates query manually. If you build one
with two or three fields, you will see how the query is structured and should
be able to modify or build a query from that example.

One thing you might try is to move the matching field(s) in the table up
toward the top (in table design view). It could be that the wizard can only
show so many fields and you have exceeded the limit of fields it can display.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top