I have made a one table database and use a form for data entry into
that database. I have made a simple search form for searching by some
important fields and use the following like criteria in query designer.
Like [Forms]![queryform].[qname] & "*"
Here query form is the name given to the search form and qname is the
name given to the Name field. Similar criteria is given to rest of the
searchable fields. When I put any criteria like for example a name Ali
in the name search field and click search it gives me the database of
all records conatining Ali. But in other fields where there is more
longer text like memo boxes, which contains full sentences, in such
search boxes even if it contains the words like counseled, referred and I
type these words in their respective search boxes, running the query
doesnt return any results. It only yeilds results if I type the very
first word written in these memo boxes but searching for the rest of
the words doesnt yield any result.
So how can I correct this by writing proper SQL language for such