>One of the problems that may exist in my database is a person having their name spelled differently, but having same SSN. In that case how would I handle this situation? Or should it even matter? Thanks
>
>Nick Patel

If you don't care wich name or agency will be included, use MIN or MAX SQL function

SELECT MAX(Sarptp.name) AS name, Sarptp.ssn, ;
      SUM(Sarptp.amt), MAX(Sarptp.agency) AS agency ;
 FROM ti!sarptp;
 GROUP BY Sarptp.ssn ;
 ORDER BY Sarptp.name