1 Reply Latest reply: Jun 1, 2010 4:13 PM by PeterDGA RSS

    Partial Data matching

      Hi,

      I have two tables, one with customer information and their full postal code (canada) and another with the first three letters of postal codes and a territory code (ex A1, A2, A3....)

      Does anybody know how I would go ahead with linking customers and their postal codes (which are 6 digits) to their respective territories?

       

       

       

        • Partial Data matching

          Create a new field where you just use the first three letters of the postal code

          Left([Postal Code],3) as [Postal Link]

          Then simply give it the same name as the field with the first 3 letters of the postal code in your second table. Done!