B
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
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