Quote:
|
Originally Posted by SilverStar
QPs and RP's aren't shouldn't be the top sorting keys. # of wins is how teams are ranked right?
|
Actually QPs are used to rank teams, QP's correspond to wins, losses and ties. A win is worth 2 QP's, a tie is worth 1 and a loss will get you 0. Teams are categorized into tiers by QP's and within those tiers are ranked by RP's. So if you were designing a database to emulate FIRST's scoreboard you would want to sort first by QP's and then secondly by RPs.
For some unsolicited advice I suggest using FileMaker instead of Access - Access is a tremendous pain to work with while FileMaker is very simple and intuitive. I haven't used Access in a while (I deleted it as soon as I possibly could) but I could definitely show you how to do this in FileMaker - it takes about ten seconds.