MS Query only allows for simple queries to be displayed. Anything more
elaborate than a simple Select/From/Where/GroupBy/Having/SortBy is not
supported. So if you have nested select statements or ... you are out of
luck. At that point you need to get into using VBA with an ADODB connection.
--
HTH...

Jim Thomlinson


"Captain Query" wrote:

I have a quite large sql query that I want to use for fetching data i´nto an
Excel sheet. The query returns four columns and I want to use parameters for
two of these.

My problem is that my sql query cant be displayed grafically in
MicrosoftQuery and therefore I am not allowed to use parameters.

My question is: What determines if a sql question can be displayed grafically?

Pleas enlighten me.

Mike