Help!!!
Can any one help i am using the follwoing query to match codes which can be anything from 4-6 digits(table A) against 7 digits(Table B)
There can be many 4-6 codes which one discription "South Korean Customers" i then when i select "South Korea" want to pull all digits from table B that start with the orignal 4-6 digit code.
I have been using the follwing Join
FROM [New codes] INNER JOIN [5 Digits] ON [New codes].
Can any one help i am using the follwoing query to match codes which can be anything from 4-6 digits(table A) against 7 digits(Table B)
There can be many 4-6 codes which one discription "South Korean Customers" i then when i select "South Korea" want to pull all digits from table B that start with the orignal 4-6 digit code.
I have been using the follwing Join
FROM [New codes] INNER JOIN [5 Digits] ON [New codes].
Code:
= Left([5 Digits].[five digits], Len([New codes].[Code]))
WHERE ((([New codes].[Description])=[Forms]![Selection]![Desc]) AND (([5 Digits].[Period])=[Forms]![Selection]![Period]));
I have had this code working but know i keep getting "Data Mismatch"
Has anyone got any ideas where i'm going wrong?
Regards
Wonderer