Need Ranking to Ignore Null

[evil44]

I've set up a query to create rankings for the teams (Team_ID, primary key) by the score (Amaze_Score). The problem I'm encountering is that it's assigning a rank of "1" to all my null score values. How can I change the text below to ignore null values in the Amaze_Score field?


Text in ranking field is:


Amaze_Rank: (SELECT Count([Team_ID]) AS HowMany FROM Teams_Table AS Dupe WHERE Dupe.Amaze_Score > Teams_Table.Amaze_Score)+1

[June7]

Maybe:

Amaze_Rank: (SELECT Count([Team_ID]) AS HowMany FROM Teams_Table AS Dupe WHERE Dupe.Amaze_Score > Teams_Table.Amaze_Score)+IIf([Amaze_Score] Is Null,0,1)

[evil44]

It seems so simple. How'd I miss that? Thanks, June7!