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.