title: Issue Using Results of a Query in Access Form
body: <pre><code>SELECT ProductData.ShiftStart, ProductData.ExtrusionLine, Avg(ProductData.RollDensity) AS AvgOfRollDensity, StDev(ProductData.RollDensity) AS StDevOfRollDensity
  FROM ProductData
  GROUP BY ProductData.ShiftStart, ProductData.ExtrusionLine
  HAVING (((ProductData.ShiftStart)=[Forms]![RollRelease]![ShiftStart]) AND ((ProductData.ExtrusionLine)=[Forms]![RollRelease]![Line]));
  </code></pre>
  <p>If I open the form &quot;RollRelease&quot;, enter data, and then run &quot;qryRollDensity&quot; with &quot;RollRelease&quot; open the query works. When I try use the query through a select statement I get mismatch errors or missing parameter errors etc. Ultimately I need the value of AvgOfRollDensity and StDevOfRollDensity in my form so I can do some calculations.</p>