Query memo text

  • Thread starter Thread starter Corinne
  • Start date Start date
C

Corinne

I have a school pupils' database that has a memo field for notes that are
added to the reports. Could anyone tell me if it is possible to filter the
pupils according to the text in a memo field.
As an example if I had made a note on a certain pupil record that they had
been suspended from school, could I run a query that just looks for the word
suspended in each memo and give me a list of those pupils? I have tried
making a query and putting the words in the criteria of the memo field but
that didn't work.
Thanks for any help
 
I have a school pupils' database that has a memo field for notes that are
added to the reports. Could anyone tell me if it is possible to filter the
pupils according to the text in a memo field.
As an example if I had made a note on a certain pupil record that they had
been suspended from school, could I run a query that just looks for the word
suspended in each memo and give me a list of those pupils? I have tried
making a query and putting the words in the criteria of the memo field but
that didn't work.
Thanks for any help
Click to expand...

As criteria in the memo field"
Like "*" & [Enter search word] & "*"
 
Thanks for that, it is going to save me a whole lot of trouble. I have tried
it out and it works really well, just what I wanted.

I have a school pupils' database that has a memo field for notes that are
added to the reports. Could anyone tell me if it is possible to filter the
pupils according to the text in a memo field.
As an example if I had made a note on a certain pupil record that they had
been suspended from school, could I run a query that just looks for the word
suspended in each memo and give me a list of those pupils? I have tried
making a query and putting the words in the criteria of the memo field but
that didn't work.
Thanks for any help
Click to expand...

As criteria in the memo field"
Like "*" & [Enter search word] & "*"

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
Click to expand...
 
I have a school pupils' database that has a memo field for notes that are
added to the reports. Could anyone tell me if it is possible to filter the
pupils according to the text in a memo field.
Click to expand...

Certainly: use a criterion of

LIKE "*" & [Enter search term:] & "*"

to be prompted for a word; or just

LIKE "*suspended*"

to find all the rascals who got caught <g>
 
Back
Top