Max and Unique

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get rid of duplicates after selecting MAX. Exp:
There are three exception rates for a record. Two of
these rates are duplicate and max. 7% and 7% and 5%. I
only want one 7% record to appear.

WHERE (((tblExcptRate.ExcptRate)=(SELECT Max([ExcptRate])
FROM tblExcptRate AS X Where X.[account] = [tblExcptRate].
[Account])));
 
Where 2 values are tied, give Access some way to determine which one to
return. For example, sort on the primary key value of the subquery:
ORDER BY tblExcptRate.ID
 
Back
Top