retreive a word

[JonyBravo]

Hi there

I have a table in my database with a field called description. Imagine if one of my discriptions is "I learn a lot in access world forums". I need a query that if I look only for a word "access" will retrieve this discription. Is this possible to be done in access?

Thanks

 

[stopher]

You can use the following as your criterion:
LIKE "*access*"

e.g.
SELECT *
FROM myTable
WHERE description LIKE "*access*"

hth
Stopher

 

[JonyBravo]

Thank you Stopher

 

[stopher]

You PM'd me with the question:

"How can I use a variable called txtWord instead the word access?"

Like '*' & txtWord & '*'


hth
Stopher

BTW, it's better to respond to the forum rather than PM someone for an answer. You'll most likely get a faster response.