Microsoft Access Scoring Help

[Rick]

Hi everyone, I am the scouting, strategy leader on 121 and was wondering if anyone had any ideas on how to incorperate match scoring into an Access database.

Right now i have a database that includes info on all the teams. I was leaning towards an idea of inputing a teams qp's and rp's in right after a match. Then have a query that will organize the teams first by qp's then by rp's.

If anyone has any ideas on how a access novice like myself could do it I would greatly appreciate it.

QPs and RP's aren't shouldn't be the top sorting keys. # of wins is how teams are ranked right?

[Rick]

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?

A win is worth 2 qp's a tie is worth 1 and a loss is worth zero. Ranking points are the losers score for each match your in (total).

[Gabriel]

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.