Query Help

  • Thread starter Thread starter Filo
  • Start date Start date
F

Filo

In the sample data below I have the problem that two identical vendor IDs
have different descriptions. How can I create a query that would isolate all
of the instances in which that happens?

Vendor ID Vendor Descr
333 ABBA
123 CHOW
123 FREO
435 LOBO


Thank you.
 
You could build a Find Duplicate query using wizard on this table. You can
do this by going into the Queries OBJECT and click NEW then click Find
Duplicates Query Wizard. The wizard will lead you through the choices. THe
key will be to pick in only the one field that you want to see with the
duplicates. The output should be a list of all the IDs that show up more than
once with a count of how many times they show up.
 
Back
Top