Search results

hi, the proceedure to calculate age in years from a birth date is clear. but i have another issue, concerning calculaction of "age categories", like Junior, Cadet and Senior. the known value is again birth date. the age <= 15 should be like Cadet, <=18 should be like Junior and >18 should be...

Hi all, I'm trying to create a filter function for a report, based on checkboxes in a form. The checkboxes in the form should be connected with specifich fields in my query. Some basic fields, like ID, name, address, tel.nr,... will be constant and checkboxes like age, specialization, membership...

Hi, I have a report grouping sport classes and use following string: ="Tax from" & " " & [od] & " (" & Count(*) & " " & IIf(Count(*)=1;"member";"members") & ")" where [od] means class name and should be written in bold. How to achieve that? Thx.

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...