Hi i'm having a couple of issues with an Access database i have. I have no macro experience and not sure if this is even the way to do it but here are my problems.
1) i have a field in a table [player] called plactive. it is a checkbox that is yes for players that are active this year. what i need to do is clear this box for the start of the season
2) is there a way to assign a value based on a birthdate? What i have is a DOB field in dd/mm/yyyy format that i would like to have the year of birth add a value in the pldivision field ie 18yrs old this year have "midget" in the pldivision field. ideally this would be a calc from the current year minus the dob year.
is there a way to do this? ideally these would be run from a command or button in a form not an automatic.
this is for about 400 individuals
thanks
1) i have a field in a table [player] called plactive. it is a checkbox that is yes for players that are active this year. what i need to do is clear this box for the start of the season
2) is there a way to assign a value based on a birthdate? What i have is a DOB field in dd/mm/yyyy format that i would like to have the year of birth add a value in the pldivision field ie 18yrs old this year have "midget" in the pldivision field. ideally this would be a calc from the current year minus the dob year.
is there a way to do this? ideally these would be run from a command or button in a form not an automatic.
this is for about 400 individuals
thanks
