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. |
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) |