2 Replies Latest reply: Jun 2, 2016 1:00 PM by mark pratt RSS

    Same SSN w/multiple similar name issue

    mark pratt

      I'm needing to have a table that will combine all the information with the same SSN and give only one name and total.

       

      Example: ssn 999 99 9999  name John Smith  acct total $500 and  ssn 999 99 9999   name John C Smith  acct total  $600

       

      Returns: ssn 999 99 9999 name John C Smith  acct total $1100

       

      Thanks in advance.