Colin has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Access Queries
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
RE: Access Queries
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