Run a query to match first 5 characters of canadian postal codes

[rubalgupta24]

Hi everyone
I always got help whenever I need some help in access or excel even without posting anything but today
I need help to run a query which will match first 5 characters of Canadian postal codes from two different fields in MS access . It's kind of urgent I am stuck due to this plz help me

 

[JonXL]

In your JOIN ... ON statement do something like...

ON LEFT(table1.postalCode,5) = LEFT(table2.postalCode,5)

Should work. Not sure about performance. If there's a better way, someone else will no doubt post it.

 

[rubalgupta24]

In your JOIN ... ON statement do something like...

ON LEFT(table1.postalCode,5) = LEFT(table2.postalCode,5)

Should work. Not sure about performance. If there's a better way, someone else will no doubt post it.

No I already tried this one its not working

 

[xenou]

You will probably need to post some sample data. Perhaps you aren't using the right words to describe the problem so try to give a more clear idea (matching the first five characters of any string is solved as JonXL posted in his answer - it is likely that there is more to the problem than what you have said).

 

[Micron]

Can you use a function in a join statement as opposed to a WHERE clause?

 

[rubalgupta24]

Thanks everyone the problem was I'm my file first expression was right