Thread: Query problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Will
 
Posts: n/a
Default 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