title: A query return only records that has the max value of field group by another field
body: <p>I made a query that has the following result:</p>
  
  <pre><code>month     OP#     JOB #   SumProd   SumScrap    
  1     10      9870    2105      21  
  1     20      9870    2018      3   
  1     30      9870    2018      0   
  1     10      8115    14581     88  
  1     20      8115    14569     35  
  1     10      8114    14581     90  
  1     20      8114    16180     268 
  </code></pre>
  
  <p>what I want to get is the result that filter this result as only the Highest OP# of Every JOB#...</p>
  
  <p>I tried like </p>
  
  <pre><code>SELECT month, Max(OP#) as maxOP, JOB # ... FROM ... GROUP BY [JOB #]...
  </code></pre>
  
  <p>But in access, it doesnt work...I appreciate if anyone could help me...I am waiting online...</p>