Help? Need to combine lists but need instr to query substrings..

[Kubie]

I'm having problems finding the syntax/comands that do the this
correctly. I'm must not be doing the join right or something..

List one
AAC1234
CDA2w31
12ZZC12
12TRE1
23234
243
....

List two
1234
A2w
C12
12TRE1

Query needs to get the substrings out. I couldn't get find the return
all the entries of list 2 in list one, but usually they are
substrings. Instr didn't work as it doesn't like static values
('1234' not list.value1)

Result
AAC1234
CDA2w31
12ZZC12
12TRE1

Suggestions?? instr is the only way I know how, but someone may have
a better approach...

Thanks,

kubie

[DeanL]

Hi Kubie,

Easiest way is to use a query like this:

SELECT Table1.[Value1]
FROM Table1, Table2
WHERE (((Table1.[Value1]) Like "*" & [Table2].[Value2] & "*"));

All this does is look for any values in table one (List 1 in your
example) that have the string contained in table two (List 2 in your
example). This is a simplification as my example assumes one field in
each table but the comparison should be the same.

Dean...

[Kubie]

On Jul 31, 4:39*pm, DeanL <[e-mail]:

HiKubie,

Easiest way is to use a query like this:

SELECT Table1.[Value1]
FROM Table1, Table2
WHERE (((Table1.[Value1]) Like "*" & [Table2].[Value2] & "*"));

All this does is look for any values in table one (List 1 in your
example) that have the string contained in table two (List 2 in your
example). *This is a simplification as my example assumes one field in
each table but the comparison should be the same.

Dean...

Worked flawlessly.... Thank you...
Kubie

[DeanL]

On Aug 1, 6:43 am, Kubie <[e-mail]:

On Jul 31, 4:39 pm, DeanL <[e-mail]:

HiKubie,

Easiest way is to use a query like this:

SELECT Table1.[Value1]
FROM Table1, Table2
WHERE (((Table1.[Value1]) Like "*" & [Table2].[Value2] & "*"));

All this does is look for any values in table one (List 1 in your
example) that have the string contained in table two (List 2 in your
example). This is a simplification as my example assumes one field in
each table but the comparison should be the same.

Dean...

Worked flawlessly.... Thank you...
Kubie

You're very welcome.

All the best, Dean...