Delete Duplicates from a query

  • Thread starter Thread starter CGo
  • Start date Start date
C

CGo

I'm using access 2007 and I have a query that finds a part number for a
device. One part number can go on many devices but I only need it to show up
once and I don't care which device it's attached to as long as it shows at
least one of the devices it's used on. Any suggestions?
 
Do a Totals Query and Group By the part number field. This would work best if
you didn't have any other fields such as the devices. If you need to display
at least on device, pick First, Last, Min, or Max for that field as
appropriate.

Jerry Whittle
 
Perfect!! Thank you. That worked great!!

Jerry Whittle said:
Do a Totals Query and Group By the part number field. This would work best if
you didn't have any other fields such as the devices. If you need to display
at least on device, pick First, Last, Min, or Max for that field as
appropriate.

Jerry Whittle
Click to expand...
 

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

Combine Duplicates in Query 0
Query returning duplicate/unexpected results 3
Dell Optiplex graphics driver failure 2
deleting duplicate records obtained from a duplicate query 4
Deleting Duplicates 2
PC often crashes, at the beginning or after pixels appear 3
No duplications 1
Access Append Query Failure 1

Back
Top