Partial Data matching

[#1]

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?

[#2]

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!