Query a memo field

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

On Thu, 8 Jul 2004 14:26:53 -0700, Jana wrote:

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

as criteria for the memo field:

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

will find a word anywhere in the field.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

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

On Thu, 8 Jul 2004 14:26:53 -0700, "Jana"
wrote:

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


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
-----Original Message-----
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".

On Thu, 8 Jul 2004 14:26:53 -0700, "Jana"
wrote:

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


Please respond to the Newsgroup, so that others may
benefit from the exchange.
Peter R. Fletcher
.