finding Duplicates

[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

 

[John Spencer]

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

 

[Query on description]

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?

 

[John Spencer]

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