Select records based on isolated portion of string

[Qaspec]

I have one table [tbl1] that contains a memo field [memof1], i have another
table that contains different alpha numeric combinations
[tblImp]![Variables]. I need to select records based on a portion of the
record equalling on of the values in the variable list.

tblImp!Variable contains data like:
A2G
B4Y

If a record in [tbl1]![memof1] contains a text string of "Yes cust stated
A2G level 8" , then I would need to select that record and so on for the
other records where a portion of the text string matches a value in my Imp
table. .

Any suggestions?

 

[vanderghast]

Have the two tables in a query. Bring the field memofl in the grid, and in
the criteria line, type:

LIKE "*" & [tblImp].[Variable] & "*"

Bring the other required fields in the grid, as needed.


Vanderghast, Access MVP