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