Parameter query in MS Query from Excel

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?
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top