Finding duplicate serial/model numbers

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

I have a database that has claims that companies have made
on certain products. Two of these fields in this database
are Serial Number and Model Number. I need a query that
looks at those claims and pull up those which have
matching Serial AND Model numbers. Is there any way to do
this?
 
Are you trying to find matching serial and model numbers
in the same record, table, or between multiple tables?
 
I am trying to find matching serial and model numbers in
the same table. For example, a match would be two records
that have the same Model Number AND Serial Number within
that table.
 
There is a built in funtion for this in access. Create a
new query. When the design options come up, select Find
Duplicates Query. Select the table you want to use and
then follow the query wizard instructions.
 
Back
Top