can i make a query in access to scan a memo field like google returns a result so it will find any of the words entered in any order

Hi Colin

Thank you for your question

Are you trying to locate a particular word or phrase in a memo field? If so simply type the word or phrase in the criteria row of your query builder, but enclose it in * marks.

For example if you were looking for the word seaweed, then simply type *seaweed* into the query designer's criteria row and this will return what you need. For multiple words simply list them on seaperate rows, again enclosed in *

Hope this is useful

Regards

Stephen