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...
 
Back
Top