Determine lowest proce

[Guest]

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

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm
for 4 ways to solve this.

 

[Guest]

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