Max and Unique

[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])));

 

[Allen Browne]

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