I am setting up a database to be used to keep a point ranking system for my table tennis school.

I have a table tblMain with records for each player. It includes a field called StartOfSeasonRa nk. I have set this to a text datatype. No calculations are performed on this field. It only stores the ranking position of the player at the start of the season and is used in the reporting.

At the start of a new season I would...