Query problem
Hello,
I know how to set up query parameters where the paramater entered
provides a value for one of the query fields. What I am struggling with
is setting up a parameterised query where the parameter entered is the
first character in a field. In other words I want to parameteries a
"begins with" criteria. In the Value field within MS Query I have
entered Like '[parameter]%' which obviously isn't working.
Can anyone tell me the correct syntax please?
Thanks in advance
Will
|