How do I set up an Access database so every year I can change age.

[Guest]

I am the administrator for our softball registration. Every year I have to
change the age and size information for each returning player. I also have to
assign them to new age groups. I have been doing this in Excel. I am
wondering if i can import the Excel information into Access and have a screen
popup for inputing a players ID # and ask for new age and size info, then let
me assign them to an age group.
Thank you for your help.

 

[Rick B]

You don't! Store their birthdate, not their age. Then you can calculate
their age in queries and reports.

The preferred age formula is...

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))