I have a problem that I have been hunting for a solution to, but to avail.
The basics are that I am trying to join 2 tables in Access by comparing a value in a field of Table 1 to a field in Table 2 that contains the number concatenated along with a few others in a list type format. (both fields are text type) 

Example.  

Table1.CWT value = 640242  

Corresponding Table2.TAG\_NO value I want to match to = 640242; 635894; 058426

So that it links the two tables based on the common value (640242 in this case).  

So far, I have tried the following: 

LEFT JOIN [Table2] ON [Table1].CWT like '\*' & [Table2].TAG\_NO & '\*' 

and 

LEFT JOIN [Table2] ON [Table1].CWT & '\*' like [Table2].TAG\_NO 

and what seems like every variation in between, I have even tried using % instead of \*. But nothing works. In some cases, the value will be the second or third element in the string (635894 in above example), so I am looking for an option that will work in all cases. This is akin to looking for the equivalent of the CONTAINS function, but that does not seem to exist either.  

Can anyone help me out?  

Thanks  

Ted