Unique Values and Top

[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.

 

[Jeff Boyce]

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.

 

[Robert]

I ended up finding a Microsoft Newsletter that worked:

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