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.