i have a query that has values for account balances, the query consists of balance amount, account id. I need to find the lowest value for each account so each account only has one balance that is the lowest existing balance.

Group By Id Min AccBal from a totals query
HTH