Log in

View Full Version : Microsoft Access Scoring Help

Rick
11-02-2004, 20:01
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.
Guest
11-02-2004, 20:03
QPs and RP's aren't shouldn't be the top sorting keys. # of wins is how teams are ranked right?
Rick
11-02-2004, 20:25
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
11-02-2004, 20:27
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.