find the highest value in one field for each value in another

[John Van Horn]

I have a query set up that returns each shipment that is not yet recieved for
several part numbers. What I would like to do is to return the highest
delivery note number for each part number, so that I can give the "last
shipment" to my supplier.