InfoSports - Youth Sports on the Web
Home » Baseball » Baseball Knowledge Base Article

Database

By: Paul Burris

The League Assistant Software is MS Access based and quite thorough for Doing league administration. I am using MS Access to "build" my own, customized to my league's particular needs.

As to the age issue:
I do it in a query. In my table of Player Information, I have a field called DOB (Date of Birth). I run a query on this table and use the following expression in a query field:

BBAge: Int(DateDiff("d",[DOB],"07-31-99",1,1)/365.25)

where the 07-31-99 date needs to be changed once a year. I then do a routine to filter off of that query to redefine each years divisional breakout.

Oh, and BTW, Can anyone tell me how the 7/31-8/1 cutoff date came about? As the father with 3 kids born in late July, I can't tell you how much I HATE it!

Anyway,
Good Luck!

Display summaries of other articles about league administration.




InfoSports Network:   NEW! ViewofHouse | iTeams.mobi | iTouchMap | iStudent.me | MPGFacts | iPicture.mobi | TweetyMap | iBoy.me
Copyright © InfoSports.com 1996-2010