First time poster and limited Access user, so bear with me.
I have a Hire Date field in a table of employess. Multiple records/employees have the same Hire Date. I want to create an additional field that will assign a value of 1 to the earliest date, 2 to the next, and so on. The end result should be that all employees with the same Hire Date will have the same seniority value. Ideally, this value should adjust as records/employees are added or deleted. Any simple solutions?