2 Replies Latest reply: Dec 28, 2010 8:38 AM by Muzammil Syed RSS

    Matching data that does not match entirely

      I want to create a report where I reflect the details from Table 1 & Table 2. I have two tables that reflect the same data but with a slight variation. In the Table 1, the persons name appears as first name, and surname as individual fields. In Table 2, the same person will appear as the the first name and surname combined however limited to 29 or 30 characters. How would I match the data correctly or link it together so that the same person may exist as one record in a report.

      Example:

      Table 1

      First name: Barry Roland James Porter Ta

      Surname: Anastasia

      Table 2:

      Agent: Barry Roland James Porter Ta A