Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Parameter question on Query in Excel | Excel Discussion (Misc queries) | |||
Excel Query Parameter | Excel Discussion (Misc queries) | |||
How to put a parameter into an Excel Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |