title: UNION Query Error - "You have tried to execute a query that does not inlude the specified expression..."
body: <p>I am trying to combine multiple queries via UNION.  When I try to execute, I get the following error:</p>
  
  <p>"You tried to execute a query that does not include the specified expression 'DateRec' as part of the aggregate function."</p>
  
  <p>Any ideas?</p>
  
  <p>Here is my Query.</p>
  
  <pre><code>SELECT [Leads Received by Agent].DateRec, [Leads Received by Agent].AgentID, 
      [Leads Received by Agent].AgentFirstName, [Leads Received by Agent].AgentLastName, 
      Count([Leads Received by Agent].LastAction) AS CountOfLastAction, 
      'Leads Received by Agent' as type 
  FROM [Leads Received by Agent]
  
  UNION ALL
  
  SELECT [Leads Proposed by Agent].DateRec, [Leads Proposed by Agent].AgentID, 
      [Leads Proposed by Agent].AgentFirstName, [Leads Proposed by Agent].AgentLastName, 
      Count([Leads Proposed by Agent].LastAction) AS NumofLeadsProp, 
      'Leads Proposed by Agent' 
  FROM [Leads Proposed by Agent]
  
  ORDER BY [Leads Received by Agent].DateRec;
  </code></pre>