MS Access Query Problems

[nrkazmi]

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

purposes.

 

[FoFa]

Try:
Like "*" & [Forms]![queryform].[qname] & "*"

 

[nrkazmi]

Thanks FoFa
It really works. Thanks again.