like function

[brino]

i want to use the "like" function in the condition section of a query ,

but i want the user to enter this somehow - either through an input box

or a form field - but it wont allow me to do this. how can i allow the
user to enter the variable into a "like" function in a query ???
thanks
brino

[Nick 'The Database Guy']

Re: like function

You simply enclosed the argument in square brackets, thus:

Like [Please input value to search for]

Good luck,

Nick
brino wrote:

i want to use the "like" function in the condition section of a query ,
>
but i want the user to enter this somehow - either through an input box
>
or a form field - but it wont allow me to do this. how can i allow the
user to enter the variable into a "like" function in a query ???
thanks
brino

[brino]

Re: like function

thanks heaps it actually worked !!
have been trying for a while to solve that.
thanks again
brino
Nick 'The Database Guy' wrote:

You simply enclosed the argument in square brackets, thus:
>
Like [Please input value to search for]
>
Good luck,
>
Nick
brino wrote:

i want to use the "like" function in the condition section of a query ,

but i want the user to enter this somehow - either through an input box

or a form field - but it wont allow me to do this. how can i allow the
user to enter the variable into a "like" function in a query ???
thanks
brino