Query a memo field

  • Thread starter Thread starter Jana
  • Start date Start date
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
 
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.
 
Do you really mean _all_ occurrences? Fred's solution will find (and
return a single copy of) each record where there is one _or_ more_
occurrence of the word in the field. Note also that his suggested
solution looks for the specified word as a string without any other
limitations - looking for "fred" with his code will also find
"alfred", "frederick", and even "alfreda".

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


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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
 
Back
Top