Find Minimum value for each change in part number

R

Ryan

I have a query with a list of purchase orders which contains the same part
number many times. I want to find the minimum price paid for each part
number. I am starting to get in a hole with this one. Can anyone help???
 
J

John W. Vinson

I have a query with a list of purchase orders which contains the same part
number many times. I want to find the minimum price paid for each part
number. I am starting to get in a hole with this one. Can anyone help???
Click to expand...

Try creating a Totals query. Select just the part number and the price; make
it a Totals query by clicking the Greek Sigma icon (looks like a sideways M).
Leave the default Group By on PartNumber and select Min on the Price field.
Open the query and you'll see all the partnumbers, each with the lowest price
for that partnumber.
 
Top