andrecarmo
New member
- Local time
- Today, 07:32
- Joined
- Sep 6, 2016
- Messages
- 3
Hi, I need some help. I have a table called "Bridge" in which i have several columns. One of those columns is called "Prod_Pack_Code_CIH_OLD" that has one or more codes. For instance, one cell may be empty or it can have one code (p.e. 123456789) or can have several codes, separeted with ";" (p.e. 1234568;123548;12345648).
What i need is a function (to be used in a query), where i can check which code , one by one, is not present in one other table, that has a column that receives only one code by cell (The other table is called Products and the column is Prod_Pack_Code).
The function has to be in VBA and i´m kind of lost in here.
Thanks
What i need is a function (to be used in a query), where i can check which code , one by one, is not present in one other table, that has a column that receives only one code by cell (The other table is called Products and the column is Prod_Pack_Code).
The function has to be in VBA and i´m kind of lost in here.
Thanks