title: In MS Access, is there any way to use a transform query as a subquery in the from clause of a subsequent query?
body: <p>I'm trying to tidy up an Access database that has way to many queries saved down the left hand side. In particular, I am attempting to consolidate multi-level queries into a single saved query where ever possible and I have run into this problem. I don't understand why the below query won't work and my google-fu has failed me. The error generated is "Syntax error in FROM clause"</p>
  
  <p>N.B. the actual query presented here isn't my exact use case, its the simplest query I could come up with that replicates the issue I'm having.</p>
  
  <pre><code>SELECT * 
  
  FROM
  
  ( TRANSFORM Sum(Calls_Offered) AS Offered
  SELECT CallDate
  FROM tblCallData
  GROUP BY CallDate
  PIVOT Call_Type ) as QryA
  
  ORDER BY 4 DESC;
  </code></pre>
  
  <p>If I save the transform query as (e.g.) QryA and then create another query like so:</p>
  
  <pre><code>SELECT *
  FROM QryA
  ORDER BY 4 DESC;
  </code></pre>
  
  <p>Then it runs fine, but as far as I was aware there shouldnt be any practical difference between the two? And if thats what I need to do, then fair enough, but I'm hoping to avoid that.</p>