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
|