Over my head

[Guest]

I am probably in way over my head here. I am trying to write a program for a
dart tournament. I am confident on creating a data base with player names
and team names. what I want to do is assign numbers to players(Averages)
from 10-30 30 being the best. =>25 Master Dart Player =>20 Averave <20 below
average. I would like it to randomly select players so no masters are
together and no below average players are together.

I am not sure if access is the program to do that or VB, Excel????

Please help.

Thank you.

Sean

 

[strive4peace]

setting up players for Dart tournament
---

Hi Sean,

Assuming you have a structure such as:

*Players*
PlayerID, autonumber
Lastname, text
Firstname, text
PlyrAvg, integer
etc

*Tournaments*
TourID, autonumber
TourDate, date
Location
etc.

*TourPlayers*
TourPlyrID, autonumber
TourID, long integer -- FK to Tournaments
PlayerID, long integer -- FK to Players

*TournamentTeams*
TeamID, autonumber
TourID, long integer -- FK to Tournaments
TeamName, text
etc

*TeamPlayers*
TeamPlyrID, autonumber
TeamID, long integer -- FK to Teams
PlayerID, long integer -- FK to Players

You will need to use VBA

Instead of making the teams totally random, why not try to get the
overall Sum of the PlyrAvg close for each team? You could Sum all the
player average and divide that by the number of teams to get the ideal
sum for each team

then, you could loop through your player recordset a few times -- once
for Masters, once for below avg players, and once for the rest. Since
you asked, I assume you are not comfortable with VBA.

How many players are on each team?

to help you understand Access a bit better, send me an email and request
my 30-page Word document on Access Basics (for Programming) -- it
doesn't cover VBA, but prepares you for it because it covers essentials
in Access. I do also send out the first 3 chapters of a book I am
writing on VBA to all who request it.

Be sure to put "Access Basics" in the subject line so that I see your
message...

~~~~

a couple things to think about:

Do you have more teams than Master players?

Do you have more teams than below average players?




Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*