Using Info from one Table in the LIKE statement of a Query

[Nate74]

Is it possible to construct a query that uses information from one table to run a series of Like OR Like... criteria?

I have created a table that contains partial part numbers and would like to query a second table for all the part numbers that contain these partial part numbers.

Meaning, BACB30DX6 would return the desired information for BACB30DX6-7, BACB30DX6-8 and so on.

The TBL_PARTS_FAM_DIA table contains approx. 200 items so 200 LIKE statements can't be the way to go... I'm hoping.

I tried: LIKE "*[TBL_PARTS_FAM_DIA]![PARTS_FAM_DIA] *" thinking that perhaps this would go through all 200 items... but of course that was wishful thinking.

Do I really need 200 LIKE statements or is there some easier way to do this.

Thanks in advance!

 

[CraigDolphin]

Maybe try this...

LIKE "*" & [TBL_PARTS_FAM_DIA]![PARTS_FAM_DIA] & "*"

 

[Nate74]

SWEEEEEET!!!!

That did it. You just saved me from about 2 hours of typing. Thank you, thank you, thank you!