SELECT contractid, min(RTRbalance) AS minRB
FROM ACHACT
GROUP BY contractid;

will have two culumn

What if I want to select all columns of ACHACT associated with minEB in each contractid group?
THX.
Jeff

Create a new query with the original table and that query, joined on the 2 appropriate fields. That should return the other data associated with that amount.