Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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!