Locating multiple entries in query

[tim1234]

Hello, I have searched the forums and found plenty of information about eliminating duplicate values. What I would like to be able to do is run a query and have it show me only the records that have the field "serial number" that contain the same number. That is, I want to be able to query and see which serial numbers have been entered more than one time. The serial number is not the primary key, this database keeps track of product repairs and is used to log them in by the primary key serial number/date. Thanks in advance for any help. Tim

 

[Vassago]

Do a search in Access help on "Find Duplicates" queries. Basically, Go to the Queries tab and press the New button. Use the Find Duplicates Query Wizard and it will help you build the query you seek.

 

[tim1234]

Thank you

Thanks for helping out those of us who are "database impared". That was too easy.