Determine lowest proce

F

Fons Ponsioen

I am drawing a total blank.
I have simple table of three fields:
PartNumber, Location, and Price.
I need to make a query showing only the lowest price for each part number
and indicate the location where this part is available.
Please help
Thanks. Fons
 
F

Fons Ponsioen

Thanks Allen, I can not believe I did not think of the summation query.
Thanks again. Have a great day.
Fons
 
Top