>>select salesRep, Sum(SalesAmount) from sales group by SalesRep order by salesRep<< Ah! Group by! Thank you.