Unique Values and Top

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Top and Unique value are set for the a whole query. How
to I exercise more control on these functions. i.e.:

tblVotes

year
candidate
votes
max_votes

Who do I get a list of winners for each year? I know It's
simple.
 
Robert

Have you looked into Totals queries, grouping by the year field?

By the way, "Year" is a reserved word in Access. If you don't rename that
field, both you and Access will probably be confused.
 
I ended up finding a Microsoft Newsletter that worked:

In (Select Top 1 [pointsWon] From AwardsShareManagers
Where [yearID]=[Managers].[yearID] Order By [pointsWon]
Desc)
 
Back
Top