Access 2010 query results 2

[dawnd3]

I feel like I should know this but I can't figure out what I am doing wrong. I ran this query asking for only records where the name field contains the word in the keywords1 field. But when I view the results, there are many records that do not have the keyword anywhere in the name. I have attached a screen shot of the query design.

 

[kray4660]

I am not 100% certain, but try this "LIKE "*"&[keyword1]&"*

 

[dawnd3]

Yes! Thank you. I knew I was missing something simple.

 

[dhookom]

Dawnd3,
Consider marking the reply as the answer by clicking the "Great post? Star it!" link.

Duane
Hook'D on Access
MS Access MVP