I meant to mention, the db is MS SQL. Thanks! -----Original Message----- Hey Casey, Try something along these lines: SELECT salesRep, Sum(salesAmount) AS salesTotal FROM sales GROUP BY salesRep What db are you using? SQL server? MySQL? Oracle? Matt