Delete Duplicates from a query

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?
 
J

Jerry Whittle

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
 
C

CGo

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