Query problem

L

Lucy

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'.
 
D

Dennis

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] & "*"
 
L

Lucy

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

Dennis said:
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] & "*"

Lucy said:
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'.
Click to expand...
Click to expand...
 
Top