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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Model & Serial Numbers 2
Find duplicates but not blank values 4
retrieving duplicate records from multiple tables 1
Need help deleting records that have one equal field 3
Select values from Multiple tables 3
Access Macro Repeat Expression using value of a field in table 0
Finding Duplicates for Part of String 4
Access Need help in making asset history in my current database. 1

Back
Top