Holy crow, it worked! The only modification I made was to sort the rank for when the tie was issued by changing the greater than to a less than between the EAD and Rank1.EAD.

Thanks again Rabbit!

Thanks for the replies guys. I was hoping to attempt this without code, so I'll keep ADezii's suggestion in my back pocket.

Thanks for the tip on the +1 Rabbit!

I know why this doesn't work, however, I'm not sure how to add a condition to the Where clause to check for a duplicate rank before checking the date:
...

Hello there,

I am fairly new to custom SQL statements in Access, so I'll do my best to communicate my request.

I am being tasked with ranking people based on a set score. The tie breaker would be their hire date, oldest date would receive the better rank. Higher the score, better the rank. with the code I found on a Microsoft support page, ID's 13 and 14 would be ranked 2 as a tie, instead I want the oldest date to tie...