Criteria for feild that contains specific word

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

Guest

I want to search the "comments" field, which has a lot of text, to look for
specific word and give me result if that field contains that word. Is that
doable? This is what I have:

Comments: This is a good feedback form, but the problem with this is that it
does not have a bigger text field.

Now I want to search for any field that contains word “text†in it.

Thanks
 
I found this from somewhere but having a liltle problem:

Like "*" & [text] & "*"

When i run the query it asks me to enter the name of what I want to search
for, i.e. "text" again in a parameter. How can I eliminate it? so users do
not have to enter anything.

Thanks
 
Hi Rizwan,

In query design, under field "comments", in the criteria area put
"*text*".
That should do the trick.

Hope this helps.
 
You are close.

Like "*text*"

When you have [Text], it is like a variable and it is asking for value to
assigned to it.
From my previous post. The "Like" operator suppose to show up when you have
criteria "*" in it.
That is why I did not put "Like" in.


Rizwan said:
I found this from somewhere but having a liltle problem:

Like "*" & [text] & "*"

When i run the query it asks me to enter the name of what I want to search
for, i.e. "text" again in a parameter. How can I eliminate it? so users do
not have to enter anything.

Thanks

Rizwan said:
I want to search the "comments" field, which has a lot of text, to look for
specific word and give me result if that field contains that word. Is that
doable? This is what I have:

Comments: This is a good feedback form, but the problem with this is that it
does not have a bigger text field.

Now I want to search for any field that contains word “text†in it.

Thanks
Click to expand...
Click to expand...
 
Back
Top