View Single Post
  #2  
Old May 24th, 2010, 08:26 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default parameter for text

I would suggest separating by space and using this --
Like "*" & [Froms].[Form].txtWords] &"*"

Remember that when you type in 'bell' you will also get 'bellows' in the
results.

--
Build a little, test a little.


"sebastico" wrote:

In Access 2003.
In a form I have a parameter to search for a word at a a time
Like [Froms].[Form].txtWords]&"*" which works well.
.
In order to enter more than two oarameter separated by commas in txtwords I
have been tryin the Str function like this
"Instr([txtWords])"
"Instr[txtWords]"

The query displays no records at all.

Could you suggest me how to do it

Many thanks