Hi all,
in excel I use folloving formula to calculate the ageclass (Senior "S", Junior "J" and Cadet "Z") for brthdate (dd.mm.yyyy):
=IF(INT((TODAY()-E2)/365,25)>18;"S";IF(F2<=15;"Z";"J"))
But now I'm trying to make a report(based on query) on same base - to calculate the ageclass. How to specify the calculation in the query criteria, so the report shows the ageclasses? And how to define a textbox in form to get the classes so, that (if possible) the ageclass is calculated and entered to table with pers.data?
THX, Pavol
in excel I use folloving formula to calculate the ageclass (Senior "S", Junior "J" and Cadet "Z") for brthdate (dd.mm.yyyy):
=IF(INT((TODAY()-E2)/365,25)>18;"S";IF(F2<=15;"Z";"J"))
But now I'm trying to make a report(based on query) on same base - to calculate the ageclass. How to specify the calculation in the query criteria, so the report shows the ageclasses? And how to define a textbox in form to get the classes so, that (if possible) the ageclass is calculated and entered to table with pers.data?
THX, Pavol
