title: Circular reference caused by alias "Expr1"
body: <p>Look at the following code, and suggest where I could be going wrong.</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT
      Table2.[Mover name],
      Table2.Lead_Type,
      Count(Table2.[Lead_Type]) AS Total_Leads,
      [Total_Charges] AS Expr1
  FROM
      Table2
  GROUP BY
      Table2.[Mover name],
      Table2.Lead_Type
  HAVING
      ((([Total_Charges])=IIf([Table2]![Lead_Type]="Intenrational (2)",
                              [Table2]![Quoted price]*[Table2]![movesouq_charge],
                              IIf([Table2]![Lead_Type]="International car",
                                  [Table2]!  [Quoted price]*[Table2]![movesouq_charge],
                                  [Query2]![Expr1]*[Table2]![movesouq_charge]
                                 )
                             )
      ));
  </code></pre>
  
  <p>When I try to run this query, an error is generated 'Circular reference caused by alias Expr1 in query definition's Select List.'</p>