Database
By: Paul BurrisThe 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!
