this should help:
<pre>SELECT tablename.TradeID, Min(tablename.TradeValue) AS Lowest
GROUP BY tablename.TradeID</pre>
“tablename” would be the name of the table that you are pulling this information from in Access.
This updated code is based on the new requirement that it show the lowest quote per TradeId. To sort the data by on column or the other add the ORDER BY command after the GROUP BY command.