Finding duplicate serial/model numbers

[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?

 

[matthew]

Are you trying to find matching serial and model numbers
in the same record, table, or between multiple tables?

 

[Ashley]

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.

 

[matthew]

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.