identifying records with embedded data (1 Viewer)

[bthill]

I have two tables: one table is a listing of company codes. The other table has part numbers and a field that describes that part number called descriptive text. I am trying to search through the descriptive text field and determine if any of the company codes from my first table exists within this memo field. I just want to identify the records. What would be the correct way to approach my problem????

Thanks!

 

[bayman]

Does a part description really need to be more than 255 characters? If not, conver the field to type 'text' and use the 'like' clause in your query.

 

[bthill]

The part description is actually more than 255 char and is formatted as a memo field. I tried using the like query and it seemed to work.