Calculating a Players Age

[Sopman]

I'm keeping the database for little league. In "Forms" I have fields labeled "birthday", "league age", and "Apr 15, 2007".
What I would like to do is when the birthdate is enter I need that to subtract from Apr 15, 2007 to give me the league age of the player. Is there a way to calculate this?

Next year I'll update Apr15, 2007 to Apr 15, 2008, but will stay in the same field. This should increase every players age by 1.

Thank You,
Sopman

 

[mp9]

Search Access help, or these forums (fora??) for the DateDiff function.

http://www22.brinkster.com/accessory/

 

[AlexCuse]

Like this?

DateDiff("yyyy",BirthDateField,#04/15/2007#)

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[MichaelRed]

actually, the search should include the term "DOB", the common acroynym for date of birth. there are several to numerous threads regarding this topic, some of which point out the potential flaw in the above post.





MichaelRed