title: ms access query for joined tables and max in group
body: <p>I am trying to link two tables, group by ID and get the max date for each ID. 
  Here is what I have:</p>
  
  <pre><code>SELECT t1.ID, Max(t2.date)
  FROM t2 INNER JOIN t1 ON t2.ID = t1.ID
  GROUP BY t1.ID;
  </code></pre>
  
  <p>when I go to Datasheet view it prompts me to enter a parameter value for t2.date</p>