Query join search

[Blair]

Newbe here…sorry if not clear


I have a query called “Compartment” pulling data from table called “comp_mod”
Example of table “comp_mod”

COMP	MOD
aaa	123
bbb	456
aaa	789
ccc	589

Within this query I have a Criteria [Comp?] under “COMP”…so the user can enter their desired comp.
If user selects “aaa”…Result would be

COMP	MOD
aaa	123
aaa	789

I want to take this query into another query and link it to another table called “Drawing”
Within this table there are multiple MOD numbers in one field..
Table “Drawing”

MOD	Drawing
123 569 789 136 596	XXX -123
596 789	KKK-789
111 226	GGG-799
112 123 998	LLL-333

Have it take the Mod return from the query above “Compartment” and search “MOD” on table “drawing.
To return

MOD	Drawing
123 569 789 136 596	XXX -123
596 789	KKK-789
112 123 998	LLL-333

Is this even possible?

[June7]

Maybe:

SELECT Drawings.* FROM Compartment, Drawings WHERE Compartment.Mod LIKE "*" & Drawings.MOD & "*";

or

SELECT Drawings.* FROM Compartment, Drawings WHERE InStr(Drawings.Mod, Compartment.Mod)>0;

[Blair]

You are the best...thx
Second suggestion worked great...