Query a memo field

J

Jana

I would like to run a query on a memo field that will show
all occurrences of one word in the field.

Is there anyway to do that.

Jana
 
F

fredg

I would like to run a query on a memo field that will show
all occurrences of one word in the field.

Is there anyway to do that.

Jana
Click to expand...

as criteria for the memo field:

Like "*" & [enter Word] & "*"

will find a word anywhere in the field.
 
G

Guest

I believe that his solution will work in my case because I
will be looking for construction terms as opposed to
names. It might actually be beneficial since I can use
shortened versions of terms and get variations.

Thanks both of you for your help.

Jana
 
Top