View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jimbo Jimbo is offline
external usenet poster
 
Posts: 35
Default Parameter query in MS Query from Excel

Im using MS Query from Excel to populate outside data I have access to. I
have a query that works fine with an expression such as Like '%%Tony Roma%%'
to search for names that appear in a particular field. I tried converting
this query to a parameter type by replacing Tony Roma in my example with
[Enter your name] and the query fails to return data or to ask for a name.
Can someone provide guidance on what Im doing wrong?