search any part of text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set a criteria in a query which will search and return a word in
any part of the field.
I have used the Like[word]&"*" criteria but it only works on the first
word.

Any help or advice gratefully recieved
 
Simon Davies said:
I need to set a criteria in a query which will search and return a word in
any part of the field.
I have used the Like[word]&"*" criteria but it only works on the
first
word.
Click to expand...

Try

Like "*" & [word] & "*"

This will find the word anywhere in the field.

Tom Lake
 
Many thanks

Newbie said:
How about Like "*" & [word] & "*"
Simon Davies said:
I need to set a criteria in a query which will search and return a word in
any part of the field.
I have used the Like[word]&"*" criteria but it only works on the first
word.

Any help or advice gratefully recieved
Click to expand...
Click to expand...
 
Brilliant - many thanks

Tom Lake said:
Simon Davies said:
I need to set a criteria in a query which will search and return a word in
any part of the field.
I have used the Like[word]&"*" criteria but it only works on the
first
word.
Click to expand...

Try

Like "*" & [word] & "*"

This will find the word anywhere in the field.

Tom Lake
Click to expand...
 
Back
Top