title: How to select a record from a recordset with maximum field value?
body: <p>I have a table "rd_details" as follows:</p>
  
  <pre><code>GNo     RD      ROI 
  11     1000    11.75
  12     2000    11.75
  12     5020    11.75
  12     2100    11.75
  11     3000    11.75
  11     4000    11.75
  </code></pre>
  
  <p>My result should be </p>
  
  <p>for GNo. 11, I should get 11, 4000, 11.75<br>
  for GNo. 12, I should get 12, 5020, 11.75     </p>
  
  <p>These are records with maximum value of the RD.
  when I key in GNo as 11  I should get RD as 4000 and ROI as 11.75</p>
  
  <p>I have the following query. I am using MS Access with VBA.</p>
  
  <pre><code>Set rst1 = dbs.OpenRecordset("select * from rd_details where gno=" &amp; Gno)
  </code></pre>
  
  <p>Kindly modify the above query keeping the <code>where</code> clause unchanged..</p>