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?

Can you post your url and/or macro or send your file to me at the address
below

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jimbo" wrote in message
...
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?