title: MS ACCESS - Max (Strength) grouping issue
body: <p>I have an Access Database which has a table that has the following fields:
       Drug_Code, Drug_Label, Alt_Drug_Code, Alt_Drug_Label, Strength, Alt_Drug_Code_10</p>
  
  <p>I am needing to perform a query that gets the max(Strength) based off of the Alt_Drug_Code_10, but then return all of the other fields.
  Problem I am having is The Alt_Drug_Code will have multiple codes within the Alt_Drug_code_10 which also has multiple labels within the Alt_Drug_Label.</p>
  
  <p>I thought I could do a First on the Order by; but that doesn't seem to be getting me what I need.  Here is what the table looks like.</p>
  
  <pre> <b>Drug_Code         Drug_Label     Alt_Drug_Code    Alt_Drug_Label  Strength   Alt_Drug_Code_10 </b><br>12345678912345      Drug1        54321987654321      AltDrug1          1          5432198765<br>12345678912345      Drug1        54321987654341      AltDrug1          5          5432198765<br>12345678912345      Drug1        98765432101234      AltDrug2          50         9876543210<br>12345678912345      Drug1        54545454540002      AltDrug3          50         5454545454<br>12345678912345      Drug1        54545454540001      AltDrug3          100        5454545454 <br>12345678912345      Drug1        54545454540003      AltDrug3          150        5454545454<br>12345678912345      Drug1        54545454540004      AltDrug3          200        5454545454<br>12345678912345      Drug1        54545454540004      AltDrug3 E2       200        5454545454<br>12345678912345      Drug1        54545454540004      AltDrug3 E3       200        5454545454<br></pre>
  
  <p>So For AltDrug1 I would only expect to see 1 line in my result with Max(Strength) = 5
  For AltDrug2 it's good/correct.
  For AltDrug3 it gets a little more complicated. I would only want to see 1 line in the end with Max(Strength) = 200 ; and it wouldn't matter which Alt_Drug_Label it chooses, could be first, last; just as long as it is Max(Strength) = 200.</p>
  
  <p>Here is my query so far:<br>
  <code>SELECT DL.DRUG_CODE, DL.DRUG_LABEL, DL.ALT_DRUG_CODE, DL.ALT_DRUG_LABEL, MAX(DL.STRENGTH), DL.ALT_DRUG_CODE_10 
  FROM DRUG_LIST DL
  GROUP BY DL.DRUG_CODE, DL.DRUG_LABEL, DL.ALT_DRUG_CODE, DL.ALT_DRUG_LABEL </CODE></p>