Camilla has attended:
Access Introduction course
Searching contents of text/memo fields
Hi
Is there a way to search the contents of a memo or text field other than using wildcards, which will bring up all the records that has that word in the related field.
For example the filter function in excel has the 'contains' or 'does not contain'
Many Thanks
RE: 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
