Query problem

[Guest]

If I have a field which is in memo format, and contains a lot of text, how do
I create a query so that just one particular word is picked out of that text?
For example if I had the following text:

apple, ball, cat, dog, elephant - how do I get access to include this entry
on a search for just 'apple'.

 

[Guest]

In the criteria row of the memo field column in your query, put this

Like "*apple*"

If you want variable text you can use Like "*" & [Enter Text] & "*"

 

[Guest]

Thanks for that Dennis.

I want to run my query via a form on which I have created a drop down list.
Therefore, I'll have to seperate all of the keywords into seperate entries on
the list. E.G:

Data
Apple, ball, cat
dog, elephant
football,
golfball

Drop down list:
Apple
Ball
Cat
Dog
Elephant
....

How can I get the drop down list to show fields with more than one entry as
seperate entries?

Thanks

In the criteria row of the memo field column in your query, put this

Like "*apple*"

If you want variable text you can use Like "*" & [Enter Text] & "*"

If I have a field which is in memo format, and contains a lot of text, how do
I create a query so that just one particular word is picked out of that text?
For example if I had the following text:

apple, ball, cat, dog, elephant - how do I get access to include this entry
on a search for just 'apple'.