Recent content by LTRService

How do I create a query to return just one record, a minimum value for one of the fields, per group within a group that contains an ID field? This is what my query is returning: ID, UPC, MinOfAverage Unit Cost 19161, 026851003663, $1.15 15927, 026851003663, $1.11 4459, 026851003663, $1.18...