parameters not allowed

[begrry]

I found a thread in here regarding MSQuery limitation to create a
parameter query when the query cannot be viewed graphically. i have
inner and outer joins and a sub query in and need this to be a
parameter query.

this was the advice given on that thread
Create a VIEW on the database server containing the SQL. Modify your
Excel app to query the VIEW rather than the base tables.

I need to make several of these queries and the IT dept is hesitant to
create views for them. Is there another way around this?

Begrry