A
ali
I have two tables.
Table 1: Consists of many companies
ID Name
1 ABC Company
2 AA Company
3 CC Banking
4 Denty Texturizing
5 LG Electronic
6 Acer Computer
7 Asus Computer
.. .
.. .
.. .
-----------------------------------------------------------------------
Table2: list of company names and their internal codes (Mapping Table)
Company_Name Internal_Code
ABC COmpany 001312
Acer Computer 013214
Asus Computer 546546
Dexin Food 054846
Sara Lee Food 540487
LG Electronics 451017
..... ......
---------------------------------------------------------------------------------------------
My Question:
I need an SQL query (if necessar) or if any other way else (please kindly
explain me!)
i need those companies (table1) to match their "Internal_Code"(table2)
automatically.
Or, is there any other built-in functions in MS Access that i do it this way ?
I know how to do this in excel (by using VLookup) ,but is there any function
that i can do it in MS Access ?.
Thank you so much ^_^!
Table 1: Consists of many companies
ID Name
1 ABC Company
2 AA Company
3 CC Banking
4 Denty Texturizing
5 LG Electronic
6 Acer Computer
7 Asus Computer
.. .
.. .
.. .
-----------------------------------------------------------------------
Table2: list of company names and their internal codes (Mapping Table)
Company_Name Internal_Code
ABC COmpany 001312
Acer Computer 013214
Asus Computer 546546
Dexin Food 054846
Sara Lee Food 540487
LG Electronics 451017
..... ......
---------------------------------------------------------------------------------------------
My Question:
I need an SQL query (if necessar) or if any other way else (please kindly
explain me!)
i need those companies (table1) to match their "Internal_Code"(table2)
automatically.
Or, is there any other built-in functions in MS Access that i do it this way ?
I know how to do this in excel (by using VLookup) ,but is there any function
that i can do it in MS Access ?.
Thank you so much ^_^!