title: Aggregate function error in Access update query using Max()
body: <pre><code>UPDATE tblFiles INNER JOIN dbo_tblStats ON tblFiles.FileName = dbo_tblStats.Video SET tblFiles.CurRecord = Max([dbo_tblstats.stopframe])
  WHERE (((tblFiles.Progress)&lt;90));
  </code></pre>
  
  <p>Intent of the code is to take the highest frame number from one table, and replace the current frame number in another table with it, on entries under 90% completion. A select query returns the Max fine, but doing an update throws the error:</p>
  
  <p>"You tried to execute a query that does not include the specified expression 'CurRecord' as part of an aggregate function."</p>
  
  <p>Help with this would be appreciated, thanks.</p>