Converting a query containing MAX into an UPDATE statement in Access
<p>I've got a table with Years, Months, Scores and I created a query to isolate the MAX score for each month. Now I want to create an update query that will mark each item in a new column, but I'm not quite sure how given the MAX. </p>

<p><code>SELECT a.Year, Max(a.Score) AS MaxOfScore, a.Month
FROM a
GROUP BY a.Year, a.Month, a.Score
HAVING (((a.Month) Is Not Null));</code></p>

<p>How do I write an update statement that adds "x" to a new column, a.High?</p>

<p>Thanks</p>