searching in a memo field.

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

Hello, I would like to create a parameter query that
searches on a memo field. The field [Description]contains
a description of a help desk ticket. I would like the
ability to serach the description field for all tickets
where a keyword (or words) entered by the user will result
in a list of matching tickets containing that word(s) in
the description field.

Thank you,
Grace
 
Hello, I would like to create a parameter query that
searches on a memo field. The field [Description]contains
a description of a help desk ticket. I would like the
ability to serach the description field for all tickets
where a keyword (or words) entered by the user will result
in a list of matching tickets containing that word(s) in
the description field.

Thank you,
Grace
Click to expand...

As criteria for the [Description] field, use:
Like "*" & [Enter word] & "*"
 
Hello, I would like to create a parameter query that
searches on a memo field. The field [Description]contains
a description of a help desk ticket. I would like the
ability to serach the description field for all tickets
where a keyword (or words) entered by the user will result
in a list of matching tickets containing that word(s) in
the description field.

Thank you,
Grace
Click to expand...

You need the LIKE operator and wildcards:

WHERE [Description] LIKE "*" & [Enter keyword] & "*"

This will work for *one* key word or key phrase, it is a bit more
complicated to get multiple keywords!
 
Back
Top