N
NeonSky via AccessMonster.com
Good Day,
For your consideration I have the following question. Please notice the below
sample datasets....
Table A
Name Confo
Joe 11111
Joe 22222
Joe 33333
Chris 55555
Will 66666
Table B
Name Confo
Joe 22222, 33333
Chris 55555
Final Dataset
Name Confo
Joe 22222
Joe 33333
Chris 55555
What I am trying to do is match the records between tables A and B. Is there
a way to have each value within a comma delimited field be searched for in
another data set?
Thank you for your time and efforts!
For your consideration I have the following question. Please notice the below
sample datasets....
Table A
Name Confo
Joe 11111
Joe 22222
Joe 33333
Chris 55555
Will 66666
Table B
Name Confo
Joe 22222, 33333
Chris 55555
Final Dataset
Name Confo
Joe 22222
Joe 33333
Chris 55555
What I am trying to do is match the records between tables A and B. Is there
a way to have each value within a comma delimited field be searched for in
another data set?
Thank you for your time and efforts!