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? |
Parameter query in MS Query from Excel
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? |
All times are GMT +1. The time now is 11:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com