Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Database (MS Access) for pool league

254 views
Skip to first unread message

Michael Chesser

unread,
May 31, 1999, 3:00:00 AM5/31/99
to
I am pretty much a novice, and I'm designing a database for our pool league.
I am stumped as to how to design a table for a schedule, that is, we've got
8 teams, and we play each Tuesday for 14 weeks (we each play eachother
twice). My ultimate goal is to have a Form for each match, which will
generate the team players, and where I can input the match results. This
information about number of wins, win percentage, etc., would be transferred
to a table, and also available for reports and analysis, for example, I
might be able to develop a "power rating" for each player based on who he
beat, by how many games, etc. At this point, I can't figure out how to
design the "schedule table", where it just has the dates and who plays who.
I would appreciate your help.

Michael Chesser
Aiken, SC
che...@scescape.net

Frank in Richmond, Va.

unread,
May 31, 1999, 3:00:00 AM5/31/99
to

Michael Chesser <che...@scescape.net> wrote in message
news:6AA43.369$Gj1....@news13.ispnews.com...

| I am pretty much a novice, and I'm designing a database for our
pool league.
| I am stumped as to how to design a table for a schedule,

I downloaded a scheduler from Mark Avlon's web page
(http://home1.gte.net/mavlon/index.htm) that was called "Home or
Away". There are two versions, the free one (Up to 8 teams) and
the Not Free one (More teams and I suppose more features). I only
needed to schedule 8 teams, so I went for the freebee. It works
great.
Frank


Jeff Wells

unread,
May 31, 1999, 3:00:00 AM5/31/99
to
Hello Michael.. I too have been attempting to write a database program to
manage our pool and dart leagues we have. I currently use TRACKER by Merit
Industries and it is GREAT! The only downside to this is that I would like
to have the ability to keep each players last 20 matches to determine their
averages, and this program is not that flexible. It is written in Access, a
version prior to 97. You can check out their homepage at
www.scorpiondarts.com.

Not that this is going to help you a bit, but what they hey!!

Jeff

Michael Chesser <che...@scescape.net> wrote in message
news:6AA43.369$Gj1....@news13.ispnews.com...
> I am pretty much a novice, and I'm designing a database for our pool
league.

Michael Chesser

unread,
Jun 1, 1999, 3:00:00 AM6/1/99
to
I have been directed to the BCA league management software, which costs $350
for non-members. Does anyone have any experience with this software? How
do you like it?

Michael from Aiken, SC

Marc D.

unread,
Jun 2, 1999, 3:00:00 AM6/2/99
to
Michael,

I was the one who forwarded your post to Chris, who got in touch with you,
and who writes the S/W for the BCA. I don't use the S/W, so I can't speak
for how well it works. But the guy who wrote it is smart and an excellent
programmer. He's also my BCA teammate, runs our BCA league, and is a great
guy who spends a lot of time making new people feel comfortable joining our
league.

Marc


Michael Chesser <che...@scescape.net> wrote in message

news:NOX43.69$xW5....@typ52b.nn.bcandid.com...

Lowleft

unread,
Jun 5, 1999, 3:00:00 AM6/5/99
to
I've been scheduling leagues for years. If you'd like to see my scheduling
templates, which were taken from a BCA publication that came out about 30 years
ago, send me an e-mail.
Gene Miller, San Franciso tournament director since 1980, National Pool League
director, and former editor of Cue Sports Journal

anilp...@gmail.com

unread,
Aug 3, 2015, 7:47:27 PM8/3/15
to
Hi LowLeft,

I'm interested in learning more about your scheduling templates. Look forward to learning more.

Thanks

Anil
0 new messages