I have a table with 3 columns: Part, Location, and Quantity. All 3 columns may contain duplicates; each part may be in several different locations, and each location may have several parts. Quantities are all over the place.
I need a query that will select each part only once, along with the location for that part, having the highest quantity.
I have tried to use the Select MAX function in all different ways, but I always get either the MAX quantity with the wrong location, or not the MAX quantity, or multiple locations for each quantity...
I hope this is clear, I'm a bit of a newbie. Any help would be appreciated, Thanks!