Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query 'Invalid pseudocolum "$D$5"
I am trying to use a cell in my spread sheet as a parameter in MS Query.
(Select data from table where field = "value in Excel cell".) Does anyone know the proper syntax to do so. I get an invalid pseudocolumn error so I am thinking there must be a 'valid' pseudocolum method. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query 'Invalid pseudocolum "$D$5"
When you create you query in MSQuery, after building the SQL, change the
desired value to ? Then when you return to Excel, right-click on the query and you the Parameters option will be available. Enter info there as required. NickHK "Johnslg" wrote in message ... I am trying to use a cell in my spread sheet as a parameter in MS Query. (Select data from table where field = "value in Excel cell".) Does anyone know the proper syntax to do so. I get an invalid pseudocolumn error so I am thinking there must be a 'valid' pseudocolum method. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query 'Invalid pseudocolum "$D$5"
I've tried the ? thing and am told that "parameters are not allowed in
queries that are too complex to be graphically displayed". :-( "NickHK" wrote: When you create you query in MSQuery, after building the SQL, change the desired value to ? Then when you return to Excel, right-click on the query and you the Parameters option will be available. Enter info there as required. NickHK "Johnslg" wrote in message ... I am trying to use a cell in my spread sheet as a parameter in MS Query. (Select data from table where field = "value in Excel cell".) Does anyone know the proper syntax to do so. I get an invalid pseudocolumn error so I am thinking there must be a 'valid' pseudocolum method. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query 'Invalid pseudocolum "$D$5"
I guess you have reached the limitations of MSQuery and should changed
something like ADO. NickHK "Johnslg" wrote in message ... I've tried the ? thing and am told that "parameters are not allowed in queries that are too complex to be graphically displayed". :-( "NickHK" wrote: When you create you query in MSQuery, after building the SQL, change the desired value to ? Then when you return to Excel, right-click on the query and you the Parameters option will be available. Enter info there as required. NickHK "Johnslg" wrote in message ... I am trying to use a cell in my spread sheet as a parameter in MS Query. (Select data from table where field = "value in Excel cell".) Does anyone know the proper syntax to do so. I get an invalid pseudocolumn error so I am thinking there must be a 'valid' pseudocolum method. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I correct Query error "Invalid bracketing of name 'xls.'." | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Clear Form results in INCORRECT "Invalid Property" message.... | Excel Programming | |||
"Invalid property" after "Clear Form" | Excel Programming | |||
"Invalid Web Query" error on opening a 2003 worksheet | Excel Discussion (Misc queries) |