View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan[_33_] Dan[_33_] is offline
external usenet poster
 
Posts: 1
Default Excel Parameters

I'm creating an MS Query using SQL and am trying to find
out if there is a way around the limitation of not being
able to use parameters [ ] in the query if it cannot be
represented graphically, as excel states it. The Problem
is that the SQL query needs to have multiple outer joins
and excel states that a query with multiple outer joins
cannot be represented graphically, and in turn parameters
cannot be used in a MS Query that cannot be represented
graphically. A catch 22. Any ideas or workarounds?