Rank formula question

[JimO]

I have a list of auto race results and want to rank by point standings. The problem I am having is that the data contains multiple race seasons and I need to be able to rank by season as well as by total points.



The formula below works fine but it does not pull out the rankings by season, the data contains a column [season] and I am hoping I can get it to work in one formula but I am unable to resolve my problem.

PtRank: IIf(IsNull([Points]),[Rank],DCount("*","IndyCARTeamT","Points>" & [Points])+1)

Thanks
Jim O

[orange]

Search the forum for rank or ranking query.