I would like to have an iif function determine the age range of the person. I have in the query grid the dob and a column called age range and would like the following.
age range: IIf(DateDiff("yyyy",[Date of Birth],Now())+Int(Format(Now(),"mmdd")<Format([Date of Birth],"mmdd"))>=11 and <=15,"11 to 15","next age range formula here")
obviously the above does not work due to the And logic. how do I implement that in the query grid function?
regards in advance
Peter
age range: IIf(DateDiff("yyyy",[Date of Birth],Now())+Int(Format(Now(),"mmdd")<Format([Date of Birth],"mmdd"))>=11 and <=15,"11 to 15","next age range formula here")
obviously the above does not work due to the And logic. how do I implement that in the query grid function?
regards in advance
Peter