Returning a minimum or maximum value from a query

[Guest]

I have a query which returns 1 or more quantity values in one field for each
product, in numerically increasing order. Is there anyway I can only return
the minimum value for each product?

 

[Guest]

Using a GroupBy query, like

SELECT TableName.Product, Min(TableName.Quantity) AS MinOfQuantity
FROM TableName
GROUP BY TableName.Product