Parameter query in MS Query from Excel

  • Thread starter Thread starter Jimbo
  • Start date Start date
J

Jimbo

I’m 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 I’m doing wrong?
 
Can you post your url and/or macro or send your file to me at the address
below
 
Back
Top