Searching contents of text/memo fields

Hi Camilla, thanks for your query. You can do this, although I'm a bit worried about your desire to not use wildcards. Is there a reason for this?

In the design view of a query use the criteria write:

Like "*internet*"

This will pull out those records where that particular field contains the word internet. You can also use "Not Like" to exclude those answers and then cascade the queries down through "Or" text boxes to run the query on multiple fields. You need the asterisk wildcards in the query, however, so the query searches within whatever text is in that field.

Hope this helps,

Anthony