Query Using Like as a Criteria

[blongmire]

I have 2 tables, the first has Job Titles, I want to search the text of those job titles to see if they match any standard terms stored in my second table.

My second table, which contains the standard terms, has multiple fields I'd like to search through to return the records that match.

For some reason, when I run a query with the Job Titles with a Criteria for Like "*" & [Table 2].[Field 1] & "*" it returns all records from my second table. I'm using the * wildcard as I don't know where in the job titles the standard terms may fall.

The end goal would be to have 1 list of my job title from table 1 and all the field names that matched from table 2 concatenated into 1 string.

I just can't seem to find a way to search through the records in all the fields on Table 2 to return only the values I want.

Does anyone have any ideas?

Thanks!

 

[ranman256]

I use this method:
make a form, put a combo box of the Titles.
make a query to search whats in the combo box

query = select * from table2 where [field1] like "*" & forms!myForm!cboTitle & "*"